﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using ElingOA6_Admin_DSJCJ.Common;
using System.Data;

namespace ElingOA6_Admin_DSJCJ.Areas.Admin.Controllers
{
    /// <summary>
    /// 打印
    /// </summary>
    public class PrintController : AdminBaseController
    {
        //
        // GET: /Admin/Print/

        /// <summary>
        /// 打印
        /// </summary>
        /// <returns></returns>
        [OutputCache(Duration = 0, VaryByParam = "none")]
        public ActionResult Index()
        {          
            
            string type = Request["type"];
            ViewData["type"] = type;

          
            switch (type) {
                case "YHHLZB":
                    {
                    //    ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmyhReport();
                    //    #region
                    //    string yyyy = Request["yyyy"];
                    //    string mm = Request["mm"];
                    //    ViewData["yyyy"] = yyyy;
                    //    ViewData["mm"] = mm;
                        
                    //    ///查询
                    //    BLL.Fwmmyhsr fwmmyhsrBll = new BLL.Fwmmyhsr();
                    //    DataSet dsdata = fwmmyhsrBll.GetDate(yyyy, mm);
                    //    ViewData["rq2"] = dsdata.Tables[0].Rows[0]["day"].ToString();

                    //    string sjrq2 = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "-"
                    //                    + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2)
                    //                    + "-" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(6, 2);

                    //    ///第3个表
                    //    BLL.Rc rcBll = new BLL.Rc();
                    //    DataSet dsdatat = rcBll.GetDate(yyyy, mm);
                    //    string sjrq5 = dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(0, 4)
                    //                    + "-" + dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(4, 2)
                    //                    + "-" + dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(6, 2);
                    //    #endregion
                    //    #region
                    //    ///第一个表
                    /////本期农行契税
                    //DataSet dsqs = fwmmyhsrBll.CountListQs(yyyy, mm);
                    //ViewData["qshsbq"] = dsqs.Tables[0].Rows.Count == 0 ? "0" : dsqs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal qshsbq = decimal.Parse(ViewData["qshsbq"].ToString());
                    //ViewData["qsjebq"] = dsqs.Tables[0].Rows.Count == 0 ? "0" : dsqs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal qsjebq = decimal.Parse(ViewData["qsjebq"].ToString());

                    /////本期农行个人所得税
                    //DataSet dsgrs = fwmmyhsrBll.CountListGrs(yyyy, mm);
                    //ViewData["grhsbq"] = dsgrs.Tables[0].Rows.Count == 0 ? "0" : dsgrs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal grhsbq = decimal.Parse(ViewData["grhsbq"].ToString());
                    //ViewData["grjebq"] = dsgrs.Tables[0].Rows.Count == 0 ? "0" : dsgrs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal grjebq = decimal.Parse(ViewData["grjebq"].ToString());

                    /////本期农行自住改善型
                    //DataSet dszh = fwmmyhsrBll.CountListZh(yyyy, mm);

                    //ViewData["zzhsbq"] = dszh.Tables[0].Rows.Count == 0 ? "0" : dszh.Tables[0].Rows[0]["sl"].ToString();
                    //decimal zzhsbq = decimal.Parse(ViewData["zzhsbq"].ToString());
                    //ViewData["zzjebq"] = dszh.Tables[0].Rows.Count == 0 ? "0" : dszh.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zzjebq = decimal.Parse(ViewData["zzjebq"].ToString());

                    /////累计农行契税
                    //DataSet dsljqs = fwmmyhsrBll.CountListLjQs(yyyy, mm);

                    //ViewData["ljqshsbq"] = dsljqs.Tables[0].Rows.Count == 0 ? "0" : dsljqs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljqshsbq = decimal.Parse(ViewData["ljqshsbq"].ToString());
                    //ViewData["ljqsjebq"] = dsljqs.Tables[0].Rows.Count == 0 ? "0" : dsljqs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljqsjebq = decimal.Parse(ViewData["ljqsjebq"].ToString());

                    /////累计农行个人所得税
                    //DataSet dsljgrs = fwmmyhsrBll.CountListLjGrs(yyyy, mm);

                    //ViewData["ljgrhsbq"] = dsljgrs.Tables[0].Rows.Count == 0 ? "0" : dsljgrs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljgrhsbq = decimal.Parse(ViewData["ljgrhsbq"].ToString());
                    //ViewData["ljgrjebq"] = dsljgrs.Tables[0].Rows.Count == 0 ? "0" : dsljgrs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljgrjebq = decimal.Parse(ViewData["ljgrjebq"].ToString());

                    /////累计农行自住改善型
                    //DataSet dsljzh = fwmmyhsrBll.CountListLjZh(yyyy, mm);

                    //ViewData["ljzzhsbq"] = dsljzh.Tables[0].Rows.Count == 0 ? "0" : dsljzh.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljzzhsbq = decimal.Parse(ViewData["ljzzhsbq"].ToString());
                    //ViewData["ljzzjebq"] = dsljzh.Tables[0].Rows.Count == 0 ? "0" : dsljzh.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljzzjebq = decimal.Parse(ViewData["ljzzjebq"].ToString());

                    /////农行期初数
                    //DataSet dsqcsa = fwmmyhsrBll.CountListQcsa(yyyy, mm);
                    //ViewData["dsqcsa"] = dsqcsa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsa.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal a = decimal.Parse(ViewData["dsqcsa"].ToString());

                    //DataSet dsqcsb = fwmmyhsrBll.CountListQcsb(yyyy, mm);
                    //ViewData["dsqcsb"] = dsqcsb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal b = decimal.Parse(ViewData["dsqcsb"].ToString());

                    //DataSet dsqcsc = fwmmyhsrBll.CountListQcsc(yyyy, mm);
                    //ViewData["dsqcsc"] = dsqcsc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcsc.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal c = decimal.Parse(ViewData["dsqcsc"].ToString());

                    //decimal d = a + b - c;
                    //ViewData["dsqcsd"] = d;

                    /////农行本期收入
                    //DataSet dssr = fwmmyhsrBll.CountListBqsr(yyyy, mm);
                    //ViewData["dssr"] = dssr.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssr.Tables[0].Rows[0]["srje"].ToString();
                    //decimal sr = decimal.Parse(ViewData["dssr"].ToString());

                    /////农行本期支出
                    //DataSet dszc = fwmmyhsrBll.CountListBqzc(yyyy, mm);
                    //ViewData["dszc"] = dszc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszc.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zc = decimal.Parse(ViewData["dszc"].ToString());
                    /////余额
                    //decimal ye = d + sr - zc;
                    //ViewData["dsye"] = ye;


                    /////鄞州银行
                    /////本期鄞州银行契税
                    //DataSet ydsqs = fwmmyhsrBll.CountListYZQs(yyyy, mm);
                    //ViewData["yqshsbq"] = ydsqs.Tables[0].Rows.Count == 0 ? "0" : ydsqs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yqshsbq = decimal.Parse(ViewData["yqshsbq"].ToString());
                    //ViewData["yqsjebq"] = ydsqs.Tables[0].Rows.Count == 0 ? "0" : ydsqs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yqsjebq = decimal.Parse(ViewData["yqsjebq"].ToString());

                    /////本期鄞州银行个人所得税
                    //DataSet ydsgrs = fwmmyhsrBll.CountListYZGrs(yyyy, mm);

                    //ViewData["ygrhsbq"] = ydsgrs.Tables[0].Rows.Count == 0 ? "0" : ydsgrs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ygrhsbq = decimal.Parse(ViewData["ygrhsbq"].ToString());
                    //ViewData["ygrjebq"] = ydsgrs.Tables[0].Rows.Count == 0 ? "0" : ydsgrs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ygrjebq = decimal.Parse(ViewData["ygrjebq"].ToString());

                    /////本期鄞州银行自住改善型
                    //DataSet ydszh = fwmmyhsrBll.CountListYZZh(yyyy, mm);

                    //ViewData["yzzhsbq"] = ydszh.Tables[0].Rows.Count == 0 ? "0" : ydszh.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yzzhsbq = decimal.Parse(ViewData["yzzhsbq"].ToString());
                    //ViewData["yzzjebq"] = ydszh.Tables[0].Rows.Count == 0 ? "0" : ydszh.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzzjebq = decimal.Parse(ViewData["yzzjebq"].ToString());

                    /////累计鄞州银行契税
                    //DataSet ydsljqs = fwmmyhsrBll.CountListYZLjQs(yyyy, mm);

                    //ViewData["yljqshsbq"] = ydsljqs.Tables[0].Rows.Count == 0 ? "0" : ydsljqs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljqshsbq = decimal.Parse(ViewData["yljqshsbq"].ToString());
                    //ViewData["yljqsjebq"] = ydsljqs.Tables[0].Rows.Count == 0 ? "0" : ydsljqs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljqsjebq = decimal.Parse(ViewData["yljqsjebq"].ToString());
                    /////累计鄞州银行个人所得税

                    //DataSet ydsljgrs = fwmmyhsrBll.CountListYZLjGrs(yyyy, mm);
                    //ViewData["yljgrhsbq"] = ydsljgrs.Tables[0].Rows.Count == 0 ? "0" : ydsljgrs.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljgrhsbq = decimal.Parse(ViewData["yljgrhsbq"].ToString());
                    //ViewData["yljgrjebq"] = ydsljgrs.Tables[0].Rows.Count == 0 ? "0" : ydsljgrs.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljgrjebq = decimal.Parse(ViewData["yljgrjebq"].ToString());

                    /////累计鄞州银行自住改善型
                    //DataSet ydsljzh = fwmmyhsrBll.CountListYZLjZh(yyyy, mm);

                    //ViewData["yljzzhsbq"] = ydsljzh.Tables[0].Rows.Count == 0 ? "0" : ydsljzh.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljzzhsbq = decimal.Parse(ViewData["yljzzhsbq"].ToString());
                    //ViewData["yljzzjebq"] = ydsljzh.Tables[0].Rows.Count == 0 ? "0" : ydsljzh.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljzzjebq = decimal.Parse(ViewData["yljzzjebq"].ToString());

                    /////鄞州银行期初数
                    //DataSet ydsqcsa = fwmmyhsrBll.CountListYZQcsa(yyyy, mm);
                    //ViewData["ydsqcsa"] = ydsqcsa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsa.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal ya = decimal.Parse(ViewData["ydsqcsa"].ToString());

                    //DataSet ydsqcsb = fwmmyhsrBll.CountListYZQcsb(yyyy, mm);
                    //ViewData["ydsqcsb"] = ydsqcsb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal yb = decimal.Parse(ViewData["ydsqcsb"].ToString());

                    //DataSet ydsqcsc = fwmmyhsrBll.CountListYZQcsc(yyyy, mm);
                    //ViewData["ydsqcsc"] = ydsqcsc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcsc.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yc = decimal.Parse(ViewData["ydsqcsc"].ToString());

                    //decimal yd = ya + yb - yc;
                    //ViewData["ydsqcsd"] = yd;

                    /////鄞州银行本期收入
                    //DataSet ydssr = fwmmyhsrBll.CountListYZBqsr(yyyy, mm);
                    //ViewData["ydssr"] = ydssr.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssr.Tables[0].Rows[0]["srje"].ToString();
                    //decimal ysr = decimal.Parse(ViewData["ydssr"].ToString());

                    /////鄞州银行本期支出
                    //DataSet ydszc = fwmmyhsrBll.CountListYZBqzc(yyyy, mm);
                    //ViewData["ydszc"] = ydszc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszc.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzc = decimal.Parse(ViewData["ydszc"].ToString());
                    /////余额
                    //decimal yye = yd + ysr - yzc;
                    //ViewData["ydsye"] = yye;

                    /////合计
                    //ViewData["hjbq"] = d + yd;
                    //ViewData["hjbqsr"] = sr + ysr;
                    //ViewData["hjbqzc"] = zc + yzc;
                    //ViewData["hjbqye"] = ye + yye;
                    //ViewData["hjqshsbq"] = qshsbq + yqshsbq;
                    //ViewData["hjqshslj"] = ljqshsbq + yljqshsbq;
                    //ViewData["hjqsjebq"] = qsjebq + yqsjebq;
                    //ViewData["hjqsjelj"] = ljqsjebq + yljqsjebq;
                    //ViewData["hjgrhsbq"] = grhsbq + ygrhsbq;
                    //ViewData["hjgrhslj"] = ljgrhsbq + yljgrhsbq;
                    //ViewData["hjgrjebq"] = grjebq + ygrjebq;
                    //ViewData["hjgrjelj"] = ljgrjebq + yljgrjebq;
                    //ViewData["hjzzhsbq"] = zzhsbq + yzzhsbq;
                    //ViewData["hjzzhslj"] = ljzzhsbq + yljzzhsbq;
                    //ViewData["hjzzjebq"] = zzjebq + yzzjebq;
                    //ViewData["hjzzjelj"] = ljzzjebq + yljzzjebq;

                    /////第二个表                   
                    /////农行期初数
                    //DataSet dsqcsaa = fwmmyhsrBll.CountListQcsa(yyyy, mm);
                    //ViewData["dsqcsaa"] = dsqcsaa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsaa.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal aa = decimal.Parse(ViewData["dsqcsaa"].ToString());

                    //DataSet dsqcsba = fwmmyhsrBll.GetQcsta(yyyy, mm);
                    //ViewData["dsqcsba"] = dsqcsba.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsba.Tables[0].Rows[0]["srje"].ToString();
                    //decimal ba = decimal.Parse(ViewData["dsqcsba"].ToString());

                    //DataSet dsqcsca = fwmmyhsrBll.GetQcstb(yyyy, mm);
                    //ViewData["dsqcsca"] = dsqcsca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcsca.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ca = decimal.Parse(ViewData["dsqcsca"].ToString());

                    //decimal da = aa + ba - ca;
                    //ViewData["dsqcsda"] = da;

                    /////农行本期收入
                    //DataSet dssra = fwmmyhsrBll.GetBqsr(yyyy, mm, sjrq2);
                    //ViewData["dssra"] = dssra.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssra.Tables[0].Rows[0]["srje"].ToString();
                    //decimal sra = decimal.Parse(ViewData["dssra"].ToString());

                    /////农行本期支出
                    //DataSet dszca = fwmmyhsrBll.GetBqzc(yyyy, mm, sjrq2);
                    //ViewData["dszca"] = dszca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszca.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zca = decimal.Parse(ViewData["dszca"].ToString());
                    /////余额
                    //decimal yea = da + sra - zca;
                    //ViewData["dsyea"] = yea;


                    /////本期农行契税
                    //DataSet dsqsa = fwmmyhsrBll.Getbqqsa(yyyy, mm, sjrq2);
                    //ViewData["qshsbqa"] = dsqsa.Tables[0].Rows.Count == 0 ? "0" : dsqsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal qshsbqa = decimal.Parse(ViewData["qshsbqa"].ToString());
                    //ViewData["qsjebqa"] = dsqsa.Tables[0].Rows.Count == 0 ? "0" : dsqsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal qsjebqa = decimal.Parse(ViewData["qsjebqa"].ToString());

                    /////累计农行契税
                    //DataSet dsljqsa = fwmmyhsrBll.Getljqsa(yyyy, mm, sjrq2);
                    //ViewData["ljqshsbqa"] = dsljqsa.Tables[0].Rows.Count == 0 ? "0" : dsljqsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljqshsbqa = decimal.Parse(ViewData["ljqshsbqa"].ToString());
                    //ViewData["ljqsjebqa"] = dsljqsa.Tables[0].Rows.Count == 0 ? "0" : dsljqsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljqsjebqa = decimal.Parse(ViewData["ljqsjebqa"].ToString());

                    /////本期农行个人所得税
                    //DataSet dsgrsa = fwmmyhsrBll.GetGrsa(yyyy, mm, sjrq2);
                    //ViewData["grhsbqa"] = dsgrsa.Tables[0].Rows.Count == 0 ? "0" : dsgrsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal grhsbqa = decimal.Parse(ViewData["grhsbqa"].ToString());
                    //ViewData["grjebqa"] = dsgrsa.Tables[0].Rows.Count == 0 ? "0" : dsgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal grjebqa = decimal.Parse(ViewData["grjebqa"].ToString());

                    /////累计农行个人所得税
                    //DataSet dsljgrsa = fwmmyhsrBll.GetLjGrsa(yyyy, mm, sjrq2);
                    //ViewData["ljgrhsbqa"] = dsljgrsa.Tables[0].Rows.Count == 0 ? "0" : dsljgrsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljgrhsbqa = decimal.Parse(ViewData["ljgrhsbq"].ToString());
                    //ViewData["ljgrjebqa"] = dsljgrsa.Tables[0].Rows.Count == 0 ? "0" : dsljgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljgrjebqa = decimal.Parse(ViewData["ljgrjebq"].ToString());

                    /////本期农行自住改善型
                    //DataSet dszha = fwmmyhsrBll.GetZha(yyyy, mm, sjrq2);

                    //ViewData["zzhsbqa"] = dszha.Tables[0].Rows.Count == 0 ? "0" : dszha.Tables[0].Rows[0]["sl"].ToString();
                    //decimal zzhsbqa = decimal.Parse(ViewData["zzhsbqa"].ToString());
                    //ViewData["zzjebqa"] = dszha.Tables[0].Rows.Count == 0 ? "0" : dszha.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zzjebqa = decimal.Parse(ViewData["zzjebqa"].ToString());

                    /////累计农行自住改善型
                    //DataSet dsljzha = fwmmyhsrBll.GetLjZha(yyyy, mm, sjrq2);
                    //ViewData["ljzzhsbqa"] = dsljzha.Tables[0].Rows.Count == 0 ? "0" : dsljzha.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljzzhsbqa = decimal.Parse(ViewData["ljzzhsbqa"].ToString());
                    //ViewData["ljzzjebqa"] = dsljzha.Tables[0].Rows.Count == 0 ? "0" : dsljzha.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljzzjebqa = decimal.Parse(ViewData["ljzzhsbqa"].ToString());

                    /////鄞州银行
                    /////鄞州银行期初数
                    //DataSet ydsqcsaa = fwmmyhsrBll.CountListYZQcsa(yyyy, mm);
                    //ViewData["ydsqcsaa"] = ydsqcsaa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsaa.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal yaa = decimal.Parse(ViewData["ydsqcsaa"].ToString());

                    //DataSet ydsqcsba = fwmmyhsrBll.GetYZQcsta(yyyy, mm);
                    //ViewData["ydsqcsba"] = ydsqcsba.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsba.Tables[0].Rows[0]["srje"].ToString();
                    //decimal yba = decimal.Parse(ViewData["ydsqcsba"].ToString());

                    //DataSet ydsqcsca = fwmmyhsrBll.GetYZQcstb(yyyy, mm);
                    //ViewData["ydsqcsca"] = ydsqcsca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcsca.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yca = decimal.Parse(ViewData["ydsqcsca"].ToString());

                    //decimal yda = yaa + yba - yca;
                    //ViewData["ydsqcsda"] = yda;

                    /////鄞州银行本期收入
                    //DataSet ydssra = fwmmyhsrBll.GetYZBqsr(yyyy, mm, sjrq2);
                    //ViewData["ydssra"] = ydssra.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssra.Tables[0].Rows[0]["srje"].ToString();
                    //decimal ysra = decimal.Parse(ViewData["ydssra"].ToString());

                    /////鄞州银行本期支出
                    //DataSet ydszca = fwmmyhsrBll.GetYZBqzc(yyyy, mm, sjrq2);
                    //ViewData["ydszca"] = ydszca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszca.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzca = decimal.Parse(ViewData["ydszca"].ToString());
                    /////余额
                    //decimal yyea = yda + ysra - yzca;
                    //ViewData["ydsyea"] = yyea;


                    /////本期农行契税
                    //DataSet ydsqsa = fwmmyhsrBll.GetYZbqqsa(yyyy, mm, sjrq2);
                    //ViewData["yqshsbqa"] = ydsqsa.Tables[0].Rows.Count == 0 ? "0" : ydsqsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yqshsbqa = decimal.Parse(ViewData["yqshsbqa"].ToString());
                    //ViewData["yqsjebqa"] = ydsqsa.Tables[0].Rows.Count == 0 ? "0" : ydsqsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yqsjebqa = decimal.Parse(ViewData["yqsjebqa"].ToString());

                    /////累计农行契税
                    //DataSet ydsljqsa = fwmmyhsrBll.GetYZljqsa(yyyy, mm, sjrq2);
                    //ViewData["yljqshsbqa"] = ydsljqsa.Tables[0].Rows.Count == 0 ? "0" : ydsljqsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljqshsbqa = decimal.Parse(ViewData["yljqshsbqa"].ToString());
                    //ViewData["yljqsjebqa"] = ydsljqsa.Tables[0].Rows.Count == 0 ? "0" : ydsljqsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljqsjebqa = decimal.Parse(ViewData["yljqsjebqa"].ToString());

                    /////本期农行个人所得税
                    //DataSet ydsgrsa = fwmmyhsrBll.GetYZGrsa(yyyy, mm, sjrq2);
                    //ViewData["ygrhsbqa"] = ydsgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsgrsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ygrhsbqa = decimal.Parse(ViewData["ygrhsbqa"].ToString());
                    //ViewData["ygrjebqa"] = ydsgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ygrjebqa = decimal.Parse(ViewData["ygrjebqa"].ToString());

                    /////累计农行个人所得税
                    //DataSet ydsljgrsa = fwmmyhsrBll.GetYZLjGrsa(yyyy, mm, sjrq2);
                    //ViewData["yljgrhsbqa"] = ydsljgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsa.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljgrhsbqa = decimal.Parse(ViewData["yljgrhsbqa"].ToString());
                    //ViewData["yljgrjebqa"] = ydsljgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljgrjebqa = decimal.Parse(ViewData["yljgrjebqa"].ToString());

                    /////本期农行自住改善型
                    //DataSet ydszha = fwmmyhsrBll.GetYZZha(yyyy, mm, sjrq2);

                    //ViewData["yzzhsbqa"] = ydszha.Tables[0].Rows.Count == 0 ? "0" : ydszha.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yzzhsbqa = decimal.Parse(ViewData["yzzhsbqa"].ToString());
                    //ViewData["yzzjebqa"] = ydszha.Tables[0].Rows.Count == 0 ? "0" : ydszha.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzzjebqa = decimal.Parse(ViewData["yzzjebqa"].ToString());

                    /////累计农行自住改善型
                    //DataSet ydsljzha = fwmmyhsrBll.GetYZLjZha(yyyy, mm, sjrq2);
                    //ViewData["yljzzhsbqa"] = ydsljzha.Tables[0].Rows.Count == 0 ? "0" : ydsljzha.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljzzhsbqa = decimal.Parse(ViewData["yljzzhsbqa"].ToString());
                    //ViewData["yljzzjebqa"] = ydsljzha.Tables[0].Rows.Count == 0 ? "0" : ydsljzha.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljzzjebqa = decimal.Parse(ViewData["yljzzjebqa"].ToString());

                    /////合计
                    //ViewData["hjbqa"] = da + yda;
                    //ViewData["hjbqsra"] = sra + ysra;
                    //ViewData["hjbqzca"] = zca + yzca;
                    //ViewData["hjbqyea"] = yea + yyea;
                    //ViewData["hjqshsbqa"] = qshsbqa + yqshsbqa;
                    //ViewData["hjqshslja"] = ljqshsbqa + yljqshsbqa;
                    //ViewData["hjqsjebqa"] = qsjebqa + yqsjebqa;
                    //ViewData["hjqsjelja"] = ljqsjebqa + yljqsjebqa;
                    //ViewData["hjgrhsbqa"] = grhsbqa + ygrhsbqa;
                    //ViewData["hjgrhslja"] = ljgrhsbqa + yljgrhsbqa;
                    //ViewData["hjgrjebqa"] = grjebqa + ygrjebqa;
                    //ViewData["hjgrjelja"] = ljgrjebqa + yljgrjebqa;
                    //ViewData["hjzzhsbqa"] = zzhsbqa + yzzhsbqa;
                    //ViewData["hjzzhslja"] = ljzzhsbqa + yljzzhsbqa;
                    //ViewData["hjzzjebqa"] = zzjebqa + yzzjebqa;
                    //ViewData["hjzzjelja"] = ljzzjebqa + yljzzjebqa;


                    /////第3个表
                    /////农行期初数
                    //DataSet dsqcsab = rcBll.CountListQcsa(yyyy, mm);
                    //ViewData["dsqcsab"] = dsqcsab.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsab.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal ab = decimal.Parse(ViewData["dsqcsab"].ToString());

                    //DataSet dsqcsbb = rcBll.GetQcsta(sjrq5);
                    //ViewData["dsqcsbb"] = dsqcsbb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsbb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal bb = decimal.Parse(ViewData["dsqcsbb"].ToString());

                    //DataSet dsqcscb = rcBll.GetQcstb(sjrq5);
                    //ViewData["dsqcscb"] = dsqcscb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcscb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal cb = decimal.Parse(ViewData["dsqcscb"].ToString());

                    //decimal db = ab + bb - cb;
                    //ViewData["dsqcsdb"] = db;

                    /////农行本期收入
                    //DataSet dssrb = rcBll.GetBqsr(yyyy, mm, sjrq5);
                    //ViewData["dssrb"] = dssrb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssrb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal srb = decimal.Parse(ViewData["dssrb"].ToString());

                    /////农行本期支出
                    //DataSet dszcb = rcBll.GetBqzc(yyyy, mm, sjrq5);
                    //ViewData["dszcb"] = dszcb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszcb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zcb = decimal.Parse(ViewData["dszcb"].ToString());
                    /////余额
                    //decimal yeb = db + srb - zcb;
                    //ViewData["dsyeb"] = yeb;


                    /////本期农行契税
                    //DataSet dsqsb = rcBll.Getbqqsa(yyyy, mm, sjrq5);
                    //ViewData["qshsbqb"] = dsqsb.Tables[0].Rows.Count == 0 ? "0" : dsqsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal qshsbqb = decimal.Parse(ViewData["qshsbqb"].ToString());
                    //ViewData["qsjebqb"] = dsqsb.Tables[0].Rows.Count == 0 ? "0" : dsqsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal qsjebqb = decimal.Parse(ViewData["qsjebqb"].ToString());

                    /////累计农行契税
                    //DataSet dsljqsb = rcBll.Getljqsa(yyyy, mm, sjrq5);
                    //ViewData["ljqshsbqb"] = dsljqsb.Tables[0].Rows.Count == 0 ? "0" : dsljqsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljqshsbqb = decimal.Parse(ViewData["ljqshsbqb"].ToString());
                    //ViewData["ljqsjebqb"] = dsljqsb.Tables[0].Rows.Count == 0 ? "0" : dsljqsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljqsjebqb = decimal.Parse(ViewData["ljqsjebqb"].ToString());

                    /////本期农行个人所得税
                    //DataSet dsgrsb = rcBll.GetGrsa(yyyy, mm, sjrq5);
                    //ViewData["grhsbqb"] = dsgrsb.Tables[0].Rows.Count == 0 ? "0" : dsgrsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal grhsbqb = decimal.Parse(ViewData["grhsbqb"].ToString());
                    //ViewData["grjebqb"] = dsgrsb.Tables[0].Rows.Count == 0 ? "0" : dsgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal grjebqb = decimal.Parse(ViewData["grjebqb"].ToString());

                    /////累计农行个人所得税
                    //DataSet dsljgrsb = rcBll.GetLjGrsa(yyyy, mm, sjrq5);
                    //ViewData["ljgrhsbqb"] = dsljgrsb.Tables[0].Rows.Count == 0 ? "0" : dsljgrsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljgrhsbqb = decimal.Parse(ViewData["ljgrhsbqb"].ToString());
                    //ViewData["ljgrjebqb"] = dsljgrsb.Tables[0].Rows.Count == 0 ? "0" : dsljgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljgrjebqb = decimal.Parse(ViewData["ljgrjebqb"].ToString());

                    /////本期农行自住改善型
                    //DataSet dszhb = rcBll.GetZha(yyyy, mm, sjrq5);

                    //ViewData["zzhsbqb"] = dszhb.Tables[0].Rows.Count == 0 ? "0" : dszhb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal zzhsbqb = decimal.Parse(ViewData["zzhsbqb"].ToString());
                    //ViewData["zzjebqb"] = dszhb.Tables[0].Rows.Count == 0 ? "0" : dszhb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal zzjebqb = decimal.Parse(ViewData["zzjebqb"].ToString());

                    /////累计农行自住改善型
                    //DataSet dsljzhb = rcBll.GetLjZha(yyyy, mm, sjrq5);
                    //ViewData["ljzzhsbqb"] = dsljzhb.Tables[0].Rows.Count == 0 ? "0" : dsljzhb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ljzzhsbqb = decimal.Parse(ViewData["ljzzhsbqb"].ToString());
                    //ViewData["ljzzjebqb"] = dsljzhb.Tables[0].Rows.Count == 0 ? "0" : dsljzhb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ljzzjebqb = decimal.Parse(ViewData["ljzzjebqb"].ToString());

                    /////鄞州银行
                    /////鄞州银行期初数
                    //DataSet ydsqcsab = rcBll.CountListYZQcsa(yyyy, mm);
                    //ViewData["ydsqcsab"] = ydsqcsab.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsab.Tables[0].Rows[0]["ncs"].ToString();
                    //decimal yab = decimal.Parse(ViewData["ydsqcsab"].ToString());

                    //DataSet ydsqcsbb = rcBll.GetYZQcsta(sjrq5);
                    //ViewData["ydsqcsbb"] = ydsqcsbb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsbb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal ybb = decimal.Parse(ViewData["ydsqcsbb"].ToString());

                    //DataSet ydsqcscb = rcBll.GetYZQcstb(sjrq5);
                    //ViewData["ydsqcscb"] = ydsqcscb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcscb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ycb = decimal.Parse(ViewData["ydsqcscb"].ToString());

                    //decimal ydb = yab + ybb - ycb;
                    //ViewData["ydsqcsdb"] = ydb;

                    /////鄞州银行本期收入
                    //DataSet ydssrb = rcBll.GetYZBqsr(yyyy, mm, sjrq5);
                    //ViewData["ydssrb"] = ydssrb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssrb.Tables[0].Rows[0]["srje"].ToString();
                    //decimal ysrb = decimal.Parse(ViewData["ydssrb"].ToString());

                    /////鄞州银行本期支出
                    //DataSet ydszcb = rcBll.GetYZBqzc(yyyy, mm, sjrq5);
                    //ViewData["ydszcb"] = ydszcb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszcb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzcb = decimal.Parse(ViewData["ydszcb"].ToString());
                    /////余额
                    //decimal yyeb = ydb + ysrb - yzcb;
                    //ViewData["ydsyeb"] = yyeb;


                    /////本期鄞州银行契税
                    //DataSet ydsqsb = rcBll.GetYZbqqsa(yyyy, mm, sjrq5);
                    //ViewData["yqshsbqb"] = ydsqsb.Tables[0].Rows.Count == 0 ? "0" : ydsqsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yqshsbqb = decimal.Parse(ViewData["yqshsbqb"].ToString());
                    //ViewData["yqsjebqb"] = ydsqsb.Tables[0].Rows.Count == 0 ? "0" : ydsqsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yqsjebqb = decimal.Parse(ViewData["yqsjebqb"].ToString());

                    /////累计农行契税
                    //DataSet ydsljqsb = rcBll.GetYZljqsa(yyyy, mm, sjrq5);
                    //ViewData["yljqshsbqb"] = ydsljqsb.Tables[0].Rows.Count == 0 ? "0" : ydsljqsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljqshsbqb = decimal.Parse(ViewData["yljqshsbqb"].ToString());
                    //ViewData["yljqsjebqb"] = ydsljqsb.Tables[0].Rows.Count == 0 ? "0" : ydsljqsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljqsjebqb = decimal.Parse(ViewData["yljqsjebqb"].ToString());

                    /////本期鄞州银行个人所得税
                    //DataSet ydsgrsb = rcBll.GetYZGrsa(yyyy, mm, sjrq5);
                    //ViewData["ygrhsbqb"] = ydsgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsgrsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal ygrhsbqb = decimal.Parse(ViewData["ygrhsbqb"].ToString());
                    //ViewData["ygrjebqb"] = ydsgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal ygrjebqb = decimal.Parse(ViewData["ygrjebqb"].ToString());

                    /////累计鄞州银行个人所得税
                    //DataSet ydsljgrsb = rcBll.GetYZLjGrsa(yyyy, mm, sjrq5);
                    //ViewData["yljgrhsbqb"] = ydsljgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljgrhsbqb = decimal.Parse(ViewData["yljgrhsbqb"].ToString());
                    //ViewData["yljgrjebqb"] = ydsljgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljgrjebqb = decimal.Parse(ViewData["yljgrjebqb"].ToString());

                    /////本期鄞州银行自住改善型
                    //DataSet ydszhb = rcBll.GetYZZha(yyyy, mm, sjrq2);

                    //ViewData["yzzhsbqb"] = ydszhb.Tables[0].Rows.Count == 0 ? "0" : ydszhb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yzzhsbqb = decimal.Parse(ViewData["yzzhsbqb"].ToString());
                    //ViewData["yzzjebqb"] = ydszhb.Tables[0].Rows.Count == 0 ? "0" : ydszhb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yzzjebqb = decimal.Parse(ViewData["yzzjebqb"].ToString());

                    /////累计鄞州银行自住改善型
                    //DataSet ydsljzhb = rcBll.GetYZLjZha(yyyy, mm, sjrq5);
                    //ViewData["yljzzhsbqb"] = ydsljzhb.Tables[0].Rows.Count == 0 ? "0" : ydsljzhb.Tables[0].Rows[0]["sl"].ToString();
                    //decimal yljzzhsbqb = decimal.Parse(ViewData["yljzzhsbqb"].ToString());
                    //ViewData["yljzzjebqb"] = ydsljzhb.Tables[0].Rows.Count == 0 ? "0" : ydsljzhb.Tables[0].Rows[0]["ybtse"].ToString();
                    //decimal yljzzjebqb = decimal.Parse(ViewData["yljzzjebqb"].ToString());

                    //DataSet ds = new DataSet();
                    //DataTable dt = new DataTable();
                    //dt.Columns.Add("dsqcsd");
                    //dt.Columns.Add("dssr");
                    //dt.Columns.Add("dszc");
                    //dt.Columns.Add("dsye");
                    //dt.Columns.Add("qshsbq");
                    //dt.Columns.Add("ljqshsbq");
                    //dt.Columns.Add("qsjebq");
                    //dt.Columns.Add("ljqsjebq");
                    //dt.Columns.Add("grhsbq");
                    //dt.Columns.Add("ljgrhsbq");
                    //dt.Columns.Add("grjebq");
                    //dt.Columns.Add("ljgrjebq");
                    //dt.Columns.Add("zzhsbq");
                    //dt.Columns.Add("ljzzhsbq");
                    //dt.Columns.Add("zzjebq");
                    //dt.Columns.Add("ljzzjebq");

                    //dt.Columns.Add("ydsqcsd");
                    //dt.Columns.Add("ydssr");
                    //dt.Columns.Add("ydszc");
                    //dt.Columns.Add("ydsye");
                    //dt.Columns.Add("yqshsbq");
                    //dt.Columns.Add("yljqshsbq");
                    //dt.Columns.Add("yqsjebq");
                    //dt.Columns.Add("yljqsjebq");
                    //dt.Columns.Add("ygrhsbq");
                    //dt.Columns.Add("yljgrhsbq");
                    //dt.Columns.Add("ygrjebq");
                    //dt.Columns.Add("yljgrjebq");
                    //dt.Columns.Add("yzzhsbq");
                    //dt.Columns.Add("yljzzhsbq");
                    //dt.Columns.Add("yzzjebq");
                    //dt.Columns.Add("yljzzjebq");

                    //dt.Columns.Add("hjbq");
                    //dt.Columns.Add("hjbqsr");
                    //dt.Columns.Add("hjbqzc");
                    //dt.Columns.Add("hjbqye");
                    //dt.Columns.Add("hjqshsbq");
                    //dt.Columns.Add("hjqshslj");
                    //dt.Columns.Add("hjqsjebq");
                    //dt.Columns.Add("hjqsjelj");
                    //dt.Columns.Add("hjgrhsbq");
                    //dt.Columns.Add("hjgrhslj");
                    //dt.Columns.Add("hjgrjebq");
                    //dt.Columns.Add("hjgrjelj");
                    //dt.Columns.Add("hjzzhsbq");
                    //dt.Columns.Add("hjzzhslj");
                    //dt.Columns.Add("hjzzjebq");
                    //dt.Columns.Add("hjzzjelj");

                    //dt.Columns.Add("dsqcsda");
                    //dt.Columns.Add("dssra");
                    //dt.Columns.Add("dszca");
                    //dt.Columns.Add("dsyea");
                    //dt.Columns.Add("qshsbqa");
                    //dt.Columns.Add("ljqshsbqa");
                    //dt.Columns.Add("qsjebqa");
                    //dt.Columns.Add("ljqsjebqa");
                    //dt.Columns.Add("grhsbqa");
                    //dt.Columns.Add("ljgrhsbqa");
                    //dt.Columns.Add("grjebqa");
                    //dt.Columns.Add("ljgrjebqa");
                    //dt.Columns.Add("zzhsbqa");
                    //dt.Columns.Add("ljzzhsbqa");
                    //dt.Columns.Add("zzjebqa");
                    //dt.Columns.Add("ljzzjebqa");

                    //dt.Columns.Add("ydsqcsda");
                    //dt.Columns.Add("ydssra");
                    //dt.Columns.Add("ydszca");
                    //dt.Columns.Add("ydsyea");
                    //dt.Columns.Add("yqshsbqa");
                    //dt.Columns.Add("yljqshsbqa");
                    //dt.Columns.Add("yqsjebqa");
                    //dt.Columns.Add("yljqsjebqa");
                    //dt.Columns.Add("ygrhsbqa");
                    //dt.Columns.Add("yljgrhsbqa");
                    //dt.Columns.Add("ygrjebqa");
                    //dt.Columns.Add("yljgrjebqa");
                    //dt.Columns.Add("yzzhsbqa");
                    //dt.Columns.Add("yljzzhsbqa");
                    //dt.Columns.Add("yzzjebqa");
                    //dt.Columns.Add("yljzzjebqa");

                    //dt.Columns.Add("hjbqa");
                    //dt.Columns.Add("hjbqsra");
                    //dt.Columns.Add("hjbqzca");
                    //dt.Columns.Add("hjbqyea");
                    //dt.Columns.Add("hjqshsbqa");
                    //dt.Columns.Add("hjqshslja");
                    //dt.Columns.Add("hjqsjebqa");
                    //dt.Columns.Add("hjqsjelja");
                    //dt.Columns.Add("hjgrhsbqa");
                    //dt.Columns.Add("hjgrhslja");
                    //dt.Columns.Add("hjgrjebqa");
                    //dt.Columns.Add("hjgrjelja");
                    //dt.Columns.Add("hjzzhsbqa");
                    //dt.Columns.Add("hjzzhslja");
                    //dt.Columns.Add("hjzzjebqa");
                    //dt.Columns.Add("hjzzjelja");

                    //dt.Columns.Add("dsqcsdb");
                    //dt.Columns.Add("dssrb");
                    //dt.Columns.Add("dszcb");
                    //dt.Columns.Add("dsyeb");
                    //dt.Columns.Add("qshsbqb");
                    //dt.Columns.Add("ljqshsbqb");
                    //dt.Columns.Add("qsjebqb");
                    //dt.Columns.Add("ljqsjebqb");
                    //dt.Columns.Add("grhsbqb");
                    //dt.Columns.Add("ljgrhsbqb");
                    //dt.Columns.Add("grjebqb");
                    //dt.Columns.Add("ljgrjebqb");
                    //dt.Columns.Add("zzhsbqb");
                    //dt.Columns.Add("ljzzhsbqb");
                    //dt.Columns.Add("zzjebqb");
                    //dt.Columns.Add("ljzzjebqb");

                    //dt.Columns.Add("ydsqcsdb");
                    //dt.Columns.Add("ydssrb");
                    //dt.Columns.Add("ydszcb");
                    //dt.Columns.Add("ydsyeb");
                    //dt.Columns.Add("yqshsbqb");
                    //dt.Columns.Add("yljqshsbqb");
                    //dt.Columns.Add("yqsjebqb");
                    //dt.Columns.Add("yljqsjebqb");
                    //dt.Columns.Add("ygrhsbqb");
                    //dt.Columns.Add("yljgrhsbqb");
                    //dt.Columns.Add("ygrjebqb");
                    //dt.Columns.Add("yljgrjebqb");
                    //dt.Columns.Add("yzzhsbqb");
                    //dt.Columns.Add("yljzzhsbqb");
                    //dt.Columns.Add("yzzjebqb");
                    //dt.Columns.Add("yljzzjebqb");

                    //dt.Columns.Add("hjbqb");
                    //dt.Columns.Add("hjbqsrb");
                    //dt.Columns.Add("hjbqzcb");
                    //dt.Columns.Add("hjbqyeb");
                    //dt.Columns.Add("hjqshsbqb");
                    //dt.Columns.Add("hjqshsljb");
                    //dt.Columns.Add("hjqsjebqb");
                    //dt.Columns.Add("hjqsjeljb");
                    //dt.Columns.Add("hjgrhsbqb");
                    //dt.Columns.Add("hjgrhsljb");
                    //dt.Columns.Add("hjgrjebqb");
                    //dt.Columns.Add("hjgrjeljb");
                    //dt.Columns.Add("hjzzhsbqb");
                    //dt.Columns.Add("hjzzhsljb");
                    //dt.Columns.Add("hjzzjebqb");
                    //dt.Columns.Add("hjzzjeljb");

                    //dt.Columns.Add("年");
                    //dt.Columns.Add("月1");
                    //dt.Columns.Add("月2");

                    //DataRow dr = dt.NewRow();

                    //dr["dsqcsd"] = d;
                    //dr["dssr"] = sr;
                    //dr["dszc"] = zc;
                    //dr["dsye"] = ye;
                    //dr["qshsbq"] = qshsbq;
                    //dr["ljqshsbq"] = ljqshsbq;
                    //dr["qsjebq"] = qsjebq;
                    //dr["ljqsjebq"] = ljqsjebq;
                    //dr["grhsbq"] = grhsbq;
                    //dr["ljgrhsbq"] = ljgrhsbq;
                    //dr["grjebq"] = grjebq;
                    //dr["ljgrjebq"] = ljgrjebq;
                    //dr["zzhsbq"] = zzhsbq;
                    //dr["ljzzhsbq"] = ljzzhsbq;
                    //dr["zzjebq"] = zzjebq;
                    //dr["ljzzjebq"] = ljzzjebq;

                    //dr["ydsqcsd"] = yd;
                    //dr["ydssr"] = ysr;
                    //dr["ydszc"] = yzc;
                    //dr["ydsye"] = yye;
                    //dr["yqshsbq"] = yqshsbq;
                    //dr["yljqshsbq"] = yljqshsbq;
                    //dr["yqsjebq"] = yqsjebq;
                    //dr["yljqsjebq"] = yljqsjebq;
                    //dr["ygrhsbq"] = ygrhsbq;
                    //dr["yljgrhsbq"] = yljgrhsbq;
                    //dr["ygrjebq"] = ygrjebq;
                    //dr["yljgrjebq"] = yljgrjebq;
                    //dr["yzzhsbq"] = yzzhsbq;
                    //dr["yljzzhsbq"] = yljzzhsbq;
                    //dr["yzzjebq"] = yzzjebq;
                    //dr["yljzzjebq"] = yljzzjebq;

                    //dr["hjbq"] = d + yd;
                    //dr["hjbqsr"] = sr + ysr;
                    //dr["hjbqzc"] = zc + yzc;
                    //dr["hjbqye"] = ye + yye;
                    //dr["hjqshsbq"] = qshsbq + yqshsbq;
                    //dr["hjqshslj"] = ljqshsbq + yljqshsbq;
                    //dr["hjqsjebq"] = qsjebq + yqsjebq;
                    //dr["hjqsjelj"] = ljqsjebq + yljqsjebq;
                    //dr["hjgrhsbq"] = grhsbq + ygrhsbq;
                    //dr["hjgrhslj"] = ljgrhsbq + yljgrhsbq;
                    //dr["hjgrjebq"] = grjebq + ygrjebq;
                    //dr["hjgrjelj"] = ljgrjebq + yljgrjebq;
                    //dr["hjzzhsbq"] = zzhsbq + yzzhsbq;
                    //dr["hjzzhslj"] = ljzzhsbq + yljzzhsbq;
                    //dr["hjzzjebq"] = zzjebq + yzzjebq;
                    //dr["hjzzjelj"] = ljzzjebq + yljzzjebq;


                    //dr["dsqcsda"] = da;
                    //dr["dssra"] = sra;
                    //dr["dszca"] = zca;
                    //dr["dsyea"] = yea;
                    //dr["qshsbqa"] = qshsbqa;
                    //dr["ljqshsbqa"] = ljqshsbqa;
                    //dr["qsjebqa"] = qsjebqa;
                    //dr["ljqsjebqa"] = ljqsjebqa;
                    //dr["grhsbqa"] = grhsbqa;
                    //dr["ljgrhsbqa"] = ljgrhsbqa;
                    //dr["grjebqa"] = grjebqa;
                    //dr["ljgrjebqa"] = ljgrjebqa;
                    //dr["zzhsbqa"] = zzhsbqa;
                    //dr["ljzzhsbqa"] = ljzzhsbqa;
                    //dr["zzjebqa"] = zzjebqa;
                    //dr["ljzzjebqa"] = ljzzjebqa;

                    //dr["ydsqcsda"] = yda;
                    //dr["ydssra"] = ysra;
                    //dr["ydszca"] = yzca;
                    //dr["ydsyea"] = yyea;
                    //dr["yqshsbqa"] = yqshsbqa;
                    //dr["yljqshsbqa"] = yljqshsbqa;
                    //dr["yqsjebqa"] = yqsjebqa;
                    //dr["yljqsjebqa"] = yljqsjebqa;
                    //dr["ygrhsbqa"] = ygrhsbqa;
                    //dr["yljgrhsbqa"] = yljgrhsbqa;
                    //dr["ygrjebqa"] = ygrjebqa;
                    //dr["yljgrjebqa"] = yljgrjebqa;
                    //dr["yzzhsbqa"] = yzzhsbqa;
                    //dr["yljzzhsbqa"] = yljzzhsbqa;
                    //dr["yzzjebqa"] = yzzjebqa;
                    //dr["yljzzjebqa"] = yljzzjebqa;

                    //dr["hjbqa"] = da + yda;
                    //dr["hjbqsra"] = sra + ysra;
                    //dr["hjbqzca"] = zca + yzca;
                    //dr["hjbqyea"] = yea + yyea;
                    //dr["hjqshsbqa"] = qshsbqa + yqshsbqa;
                    //dr["hjqshslja"] = ljqshsbqa + yljqshsbqa;
                    //dr["hjqsjebqa"] = qsjebqa + yqsjebqa;
                    //dr["hjqsjelja"] = ljqsjebqa + yljqsjebqa;
                    //dr["hjgrhsbqa"] = grhsbqa + ygrhsbqa;
                    //dr["hjgrhslja"] = ljgrhsbqa + yljgrhsbqa;
                    //dr["hjgrjebqa"] = grjebqa + ygrjebqa;
                    //dr["hjgrjelja"] = ljgrjebqa + yljgrjebqa;
                    //dr["hjzzhsbqa"] = zzhsbqa + yzzhsbqa;
                    //dr["hjzzhslja"] = ljzzhsbqa + yljzzhsbqa;
                    //dr["hjzzjebqa"] = zzjebqa + yzzjebqa;
                    //dr["hjzzjelja"] = ljzzjebqa + yljzzjebqa;

                    //dr["dsqcsdb"] = db;
                    //dr["dssrb"] = srb;
                    //dr["dszcb"] = zcb;
                    //dr["dsyeb"] = yeb;
                    //dr["qshsbqb"] = qshsbqb;
                    //dr["ljqshsbqb"] = ljqshsbqb;
                    //dr["qsjebqb"] = qsjebqb;
                    //dr["ljqsjebqb"] = ljqsjebqb;
                    //dr["grhsbqb"] = grhsbqb;
                    //dr["ljgrhsbqb"] = ljgrhsbqb;
                    //dr["grjebqb"] = grjebqb;
                    //dr["ljgrjebqb"] = ljgrjebqb;
                    //dr["zzhsbqb"] = zzhsbqb;
                    //dr["ljzzhsbqb"] = ljzzhsbqb;
                    //dr["zzjebqb"] = zzjebqb;
                    //dr["ljzzjebqb"] = ljzzjebqb;

                    //dr["ydsqcsdb"] = ydb;
                    //dr["ydssrb"] = ysrb;
                    //dr["ydszcb"] = yzcb;
                    //dr["ydsyeb"] = yyeb;
                    //dr["yqshsbqb"] = yqshsbqb;
                    //dr["yljqshsbqb"] = yljqshsbqb;
                    //dr["yqsjebqb"] = yqsjebqb;
                    //dr["yljqsjebqb"] = yljqsjebqb;
                    //dr["ygrhsbqb"] = ygrhsbqb;
                    //dr["yljgrhsbqb"] = yljgrhsbqb;
                    //dr["ygrjebqb"] = ygrjebqb;
                    //dr["yljgrjebqb"] = yljgrjebqb;
                    //dr["yzzhsbqb"] = yzzhsbqb;
                    //dr["yljzzhsbqb"] = yljzzhsbqb;
                    //dr["yzzjebqb"] = yzzjebqb;
                    //dr["yljzzjebqb"] = yljzzjebqb;

                    //dr["hjbqb"] = db + ydb;
                    //dr["hjbqsrb"] = srb + ysrb;
                    //dr["hjbqzcb"] = zcb + yzcb;
                    //dr["hjbqyeb"] = yeb + yyeb;
                    //dr["hjqshsbqb"] = qshsbqb + yqshsbqb;
                    //dr["hjqshsljb"] = ljqshsbqb + yljqshsbqb;
                    //dr["hjqsjebqb"] = qsjebqb + yqsjebqb;
                    //dr["hjqsjeljb"] = ljqsjebqb + yljqsjebqb;
                    //dr["hjgrhsbqb"] = grhsbqb + ygrhsbqb;
                    //dr["hjgrhsljb"] = ljgrhsbqb + yljgrhsbqb;
                    //dr["hjgrjebqb"] = grjebqb + ygrjebqb;
                    //dr["hjgrjeljb"] = ljgrjebqb + yljgrjebqb;
                    //dr["hjzzhsbqb"] = zzhsbqb + yzzhsbqb;
                    //dr["hjzzhsljb"] = ljzzhsbqb + yljzzhsbqb;
                    //dr["hjzzjebqb"] = zzjebqa + yzzjebqb;
                    //dr["hjzzjeljb"] = ljzzjebqb + yljzzjebqb;

                    //dr["年"] = yyyy;
                    //dr["月1"] = mm;
                    //dr["月2"] = Int32.Parse(mm) + 1 + "";


                    //ViewData["data"] = ds;

                    return View("FwmmyhIndex");
                    //    #endregion
                    }

                case "ZJGSXBT":
                    {
                        ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtzReport();
                        #region
                        BLL.Fwmmszbt fwmmszbtzBll = new BLL.Fwmmszbt();
                        string where = "sz='自住改善型'";

                        string yyyy = Request.Params["yyyy"];
                        string mm = Request.Params["mm"];
                        string nsr = Request.Params["nsr"];
                        string sfz = Request.Params["sfz"];
                        string btbl = Request.Params["btbl"];
                        string khyh = Request.Params["khyh"];
                        string btrq = Request.Params["btrq"];

                        string setrq = Request.Params["setrq"];
                        
                        ViewData["yyyy"] = yyyy;
                        ViewData["mm"] = mm;
                        ViewData["nsr"] = nsr;
                        ViewData["sfz"] = sfz;
                        ViewData["btbl"] = btbl;
                        ViewData["khyh"] = khyh;
                        ViewData["btrq"] = btrq;

                        if (yyyy != null && yyyy != "")
                        {
                            where += "and datepart(year,btrq) ='" + yyyy + "'";
                        }
                        if (mm != null && mm != "")
                        {
                            where += "and datepart(mm,btrq) ='" + mm + "'";
                        }
                        if (nsr != null && nsr != "")
                        {
                            where += "and nsr like '%" + nsr + "%'";
                        }
                        if (btbl != null && btbl != "")
                        {
                            where += "and btbl = '" + btbl + "'";
                        }
                        if (khyh != null && khyh != "")
                        {
                            where += "and khyh = '" + khyh + "'";
                        }
                        if (sfz != null && sfz != "")
                        {
                            where += "and sfz = '" + sfz + "'";
                        }
                        if (btrq != null && btrq != "")
                        {
                            where += " and btrq = convert(datetime,'" + btrq + "') ";
                        }
                        DataSet dsAll = fwmmszbtzBll.GetAllList(where);

                        DataSet ds = new DataSet();
                        DataTable dt = new DataTable();
                        DataRow dr = dt.NewRow();
                        dt.Columns.Add("编号");
                        dt.Columns.Add("纳税人");
                        dt.Columns.Add("身份证");
                        dt.Columns.Add("房价总额");
                        dt.Columns.Add("补贴额度（%）");
                        dt.Columns.Add("应补贴税额（元）");
                        dt.Columns.Add("开户银行");
                        dt.Columns.Add("帐号");
                        //dt.Columns.Add("合计已缴税款（元）");
                        //dt.Columns.Add("合计应补贴税额（元）");
                        //dt.Columns.Add("日期");
                        //dt.Columns.Add("月");
                        
                        decimal yjsksum = 0;
                        decimal ybtjesum = 0;

                        if (yyyy != null && yyyy != "")
                        {
                            btrq = yyyy + "年";
                        }
                        if (mm != null && mm != "")
                        {
                            btrq = yyyy + "年" + mm + "月";
                        }
                        DataSet dsData = fwmmszbtzBll.GetChangeData(where);
                        if (dsData.Tables[0].Rows.Count > 0) 
                        {
                            foreach (DataRow drow in dsData.Tables[0].Rows) 
                            {
                                if (Int32.Parse(drow["cou"].ToString()) == 1) 
                                { 
                                    string day = drow["day"].ToString();
                                    btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月" + day.Substring(6, 2) + "日";

                                    if (day.Substring(6, 2) == "11") 
                                    {
                                        btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月20日";
                                    }

                                    if (day.Substring(6, 2) == "25")
                                    {
                                        DataSet dsdata = fwmmszbtzBll.GetData(day);

                                        btrq = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "年" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2) + "月5日";
                                    }
                                }
                            }
                        }

                        if (setrq != "" && setrq != null)
                        {
                            btrq = setrq;
                        }
                        else
                        {
                            setrq = btrq;
                        }

                        int count = 0;
                        for (int i = 0; i < dsAll.Tables[0].Rows.Count; i++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = i + 1;
                            dr["纳税人"] = dsAll.Tables[0].Rows[i]["nsr"].ToString();
                            dr["身份证"] = dsAll.Tables[0].Rows[i]["sfz"].ToString();
                            dr["房价总额"] = dsAll.Tables[0].Rows[i]["yjsk"].ToString();
                            dr["补贴额度（%）"] = dsAll.Tables[0].Rows[i]["btbl"].ToString() + "%";
                            dr["应补贴税额（元）"] = dsAll.Tables[0].Rows[i]["ybtse"].ToString();
                            dr["开户银行"] = dsAll.Tables[0].Rows[i]["khyh"].ToString();
                            dr["帐号"] = dsAll.Tables[0].Rows[i]["zh"].ToString();
                            decimal hjyjsk = decimal.Parse(dsAll.Tables[0].Rows[i]["yjsk"].ToString());
                            decimal hjybtse = decimal.Parse(dsAll.Tables[0].Rows[i]["ybtse"].ToString());
                            yjsksum += hjyjsk;
                            ybtjesum += hjybtse;
                            //dr["日期"] = btrq;
                            //dr["月"] = mm;
                            //dr["合计已缴税款（元）"] = yjsksum;
                            //dr["合计应补贴税额（元）"] = ybtjesum;
                            dt.Rows.Add(dr);
                            count++;
                        }
                        int sum = 22 - count % 24;
                        for (int j = 0; j < sum; j++) 
                        {
                            dr = dt.NewRow();
                            dr["编号"] = "";
                            dr["纳税人"] = "";
                            dr["身份证"] = "";
                            dr["房价总额"] = "";
                            dr["补贴额度（%）"] = "";
                            dr["应补贴税额（元）"] = "";
                            dr["开户银行"] = "";
                            dr["帐号"] = "";
                            dt.Rows.Add(dr);
                        }


                        dr = dt.NewRow();
                        dr["编号"] = "";
                        dr["纳税人"] = "合计";
                        dr["身份证"] = "";
                        dr["房价总额"] = yjsksum;
                        dr["补贴额度（%）"] = "";
                        dr["应补贴税额（元）"] = ybtjesum;
                        dr["开户银行"] = "";
                        dr["帐号"] = "";
                        dt.Rows.Add(dr);

                        //dr = dt.NewRow();
                        //dr["编号"] = "";
                        //dr["纳税人"] = "经办人:";
                        //dr["身份证"] = "";
                        //dr["房价总额"] = "科长（签字）:";
                        //dr["补贴额度（%）"] = "";
                        //dr["应补贴税额（元）"] = "局长（签字）:";
                        //dr["开户银行"] = "";
                        //dr["帐号"] = "";
                        //dt.Rows.Add(dr);


                        ds.Tables.Add(dt);

                        ViewData["dataszbt"] = ds;

                        ViewData["Param_PrintDate"] = setrq;
                        return View("FwmmszbtzIndex");
                        #endregion
                    }

                case "FWMMCZBT":
                    {

                        ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtReport();
                        #region
                        BLL.Fwmmszbt fwmmszbtzBll = new BLL.Fwmmszbt();
                        string where = "sz<>'自住改善型'";

                        string yyyy = Request.Params["yyyy"];
                        string mm = Request.Params["mm"];
                        string nsr = Request.Params["nsr"];
                        string sfz = Request.Params["sfz"];
                        string btbl = Request.Params["btbl"];
                        string khyh = Request.Params["khyh"];
                        string btrq = Request.Params["btrq"];
                        string sz = Request.Params["sz"];

                        string setrq = Request.Params["setrq"];

                        ViewData["yyyy"] = yyyy;
                        ViewData["mm"] = mm;
                        ViewData["nsr"] = nsr;
                        ViewData["sfz"] = sfz;
                        ViewData["btbl"] = btbl;
                        ViewData["khyh"] = khyh;
                        ViewData["btrq"] = btrq;
                        ViewData["sz"] = sz;

                        if (yyyy != null && yyyy != "")
                        {
                            where += "and datepart(year,btrq) ='" + yyyy + "'";
                        }
                        if (mm != null && mm != "")
                        {
                            where += "and datepart(mm,btrq) ='" + mm + "'";
                        }
                        if (nsr != null && nsr != "")
                        {
                            where += "and nsr like '%" + nsr + "%'";
                        }
                        if (btbl != null && btbl != "")
                        {
                            where += "and btbl = '" + btbl + "'";
                        }
                        if (khyh != null && khyh != "")
                        {
                            where += "and khyh = '" + khyh + "'";
                        }
                        if (sfz != null && sfz != "")
                        {
                            where += "and sfz = '" + sfz + "'";
                        }
                        if (btrq != null && btrq != "")
                        {
                            where += " and btrq = convert(datetime,'" + btrq + "') ";
                        }
                        if (sz != null && sz != "")
                        {
                            where += " and sz ='" + sz + "'";
                            if (sz == "契税")
                            {
                                sz = "个人普通房屋买卖契税财政补贴审批汇总表";
                            }
                            else if (sz == "个人所得税")
                            {
                                sz = "个人普通房屋买卖个人所得税财政补贴审批汇总表";
                            }
                            else
                            {
                                sz = "个人普通房屋买卖财政补贴审批汇总表";
                            }
                        }
                        else
                        {
                            sz = "个人普通房屋买卖财政补贴审批汇总表";
                        }
                        DataSet dsAll = fwmmszbtzBll.GetAllList(where);

                        DataSet ds = new DataSet();
                        DataTable dt = new DataTable();
                        DataRow dr = dt.NewRow();
                        dt.Columns.Add("编号");
                        dt.Columns.Add("纳税人");
                        dt.Columns.Add("身份证");
                        dt.Columns.Add("已缴税款（元）");
                        dt.Columns.Add("补贴额度（%）");
                        dt.Columns.Add("应补贴税额（元）");
                        dt.Columns.Add("开户银行");
                        dt.Columns.Add("帐号");
                        //dt.Columns.Add("合计已缴税款（元）");
                        //dt.Columns.Add("合计应补贴税额（元）");
                        //dt.Columns.Add("日期");
                        //dt.Columns.Add("月");
                        dt.Columns.Add("税种");
                        decimal yjsksum = 0;
                        decimal ybtjesum = 0;


                        DataSet dsData = fwmmszbtzBll.GetChangeData(where);
                        if (dsData.Tables[0].Rows.Count > 0)
                        {
                            foreach (DataRow drow in dsData.Tables[0].Rows)
                            {
                                if (Int32.Parse(drow["cou"].ToString()) == 1)
                                {
                                    string day = drow["day"].ToString();
                                    btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月" + day.Substring(6, 2) + "日";

                                    if (day.Substring(6, 2) == "11")
                                    {
                                        btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月20日";
                                    }

                                    if (day.Substring(6, 2) == "25")
                                    {
                                        DataSet dsdata = fwmmszbtzBll.GetData(day);

                                        btrq = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "年" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2) + "月5日";
                                    }
                                }
                            }
                        }
                        if (setrq != "" && setrq != null)
                        {
                            btrq = setrq;
                        }
                        else
                        {
                            setrq = btrq;
                        }


                        int count = 0;

                        for (int i = 0; i < dsAll.Tables[0].Rows.Count; i++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = i + 1;
                            dr["纳税人"] = dsAll.Tables[0].Rows[i]["nsr"].ToString();
                            dr["身份证"] = dsAll.Tables[0].Rows[i]["sfz"].ToString();
                            dr["已缴税款（元）"] = dsAll.Tables[0].Rows[i]["yjsk"].ToString();
                            dr["补贴额度（%）"] = dsAll.Tables[0].Rows[i]["btbl"].ToString() + "%";
                            dr["应补贴税额（元）"] = dsAll.Tables[0].Rows[i]["ybtse"].ToString();
                            dr["开户银行"] = dsAll.Tables[0].Rows[i]["khyh"].ToString();
                            dr["帐号"] = dsAll.Tables[0].Rows[i]["zh"].ToString();
                            decimal hjyjsk = decimal.Parse(dsAll.Tables[0].Rows[i]["yjsk"].ToString());
                            decimal hjybtse = decimal.Parse(dsAll.Tables[0].Rows[i]["ybtse"].ToString());
                            yjsksum += hjyjsk;
                            ybtjesum += hjybtse;
                            //dr["合计已缴税款（元）"] = yjsksum;
                            //dr["合计应补贴税额（元）"] = ybtjesum;

                            //dr["日期"] = btrq;
                            //dr["月"] = mm;
                            dr["税种"] = sz;

                            count++;

                            dt.Rows.Add(dr);
                        }
                        int sum = 22 - count % 24;
                        for (int j = 0; j < sum; j++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = "";
                            dr["纳税人"] = "";
                            dr["身份证"] = "";
                            dr["已缴税款（元）"] = "";
                            dr["补贴额度（%）"] = "";
                            dr["应补贴税额（元）"] = "";
                            dr["开户银行"] = "";
                            dr["帐号"] = "";
                            dr["税种"] = sz;
                            dt.Rows.Add(dr);
                        }


                        dr = dt.NewRow();
                        dr["编号"] = "";
                        dr["纳税人"] = "合计";
                        dr["身份证"] = "";
                        dr["已缴税款（元）"] = yjsksum;
                        dr["补贴额度（%）"] = "";
                        dr["应补贴税额（元）"] = ybtjesum;
                        dr["开户银行"] = "";
                        dr["帐号"] = "";
                        dt.Rows.Add(dr);

                        //dr = dt.NewRow();
                        //dr["编号"] = "";
                        //dr["纳税人"] = "经办人:";
                        //dr["身份证"] = "";
                        //dr["已缴税款（元）"] = "科长（签字）:";
                        //dr["补贴额度（%）"] = "";
                        //dr["应补贴税额（元）"] = "局长（签字）:";
                        //dr["开户银行"] = "";
                        //dr["帐号"] = "";
                        //dt.Rows.Add(dr);



                        ds.Tables.Add(dt);
                        ViewData["Param_PrintDate"] = setrq;
                        ViewData["data"] = ds;


                        return View("FwmmszbtIndex");

                        #endregion
                    }
           
            }
            return View();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public ActionResult ReportViewerPartial()
        {
            string type = Request["type"];
            ViewData["type"] = type;          
            switch (type)
            {
                case "YHHLZB":
                    {
                        //ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmyhReport();
                        //#region
                        //string yyyy = Request["yyyy"];
                        //string mm = Request["mm"];
                        //ViewData["yyyy"] = yyyy;
                        //ViewData["mm"] = mm;
                        
                        /////查询
                        //BLL.Fwmmyhsr fwmmyhsrBll = new BLL.Fwmmyhsr();
                        //DataSet dsdata = fwmmyhsrBll.GetDate(yyyy, mm);
                        //ViewData["rq2"] = dsdata.Tables[0].Rows[0]["day"].ToString();

                        //string sjrq2 = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "-"
                        //                + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2)
                        //                + "-" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(6, 2);
                        /////第3个表
                        //BLL.Rc rcBll = new BLL.Rc();
                        //DataSet dsdatat = rcBll.GetDate(yyyy, mm);
                        //string sjrq5 = dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(0, 4)
                        //                + "-" + dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(4, 2)
                        //                + "-" + dsdatat.Tables[0].Rows[0]["day"].ToString().Substring(6, 2);
                        //#endregion
                        //#region
                        /////第一个表
                        /////本期农行契税
                        //DataSet dsqs = fwmmyhsrBll.CountListQs(yyyy, mm);
                        //ViewData["qshsbq"] = dsqs.Tables[0].Rows.Count == 0 ? "0" : dsqs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal qshsbq = decimal.Parse(ViewData["qshsbq"].ToString());
                        //ViewData["qsjebq"] = dsqs.Tables[0].Rows.Count == 0 ? "0" : dsqs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal qsjebq = decimal.Parse(ViewData["qsjebq"].ToString());

                        /////本期农行个人所得税
                        //DataSet dsgrs = fwmmyhsrBll.CountListGrs(yyyy, mm);
                        //ViewData["grhsbq"] = dsgrs.Tables[0].Rows.Count == 0 ? "0" : dsgrs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal grhsbq = decimal.Parse(ViewData["grhsbq"].ToString());
                        //ViewData["grjebq"] = dsgrs.Tables[0].Rows.Count == 0 ? "0" : dsgrs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal grjebq = decimal.Parse(ViewData["grjebq"].ToString());

                        /////本期农行自住改善型
                        //DataSet dszh = fwmmyhsrBll.CountListZh(yyyy, mm);

                        //ViewData["zzhsbq"] = dszh.Tables[0].Rows.Count == 0 ? "0" : dszh.Tables[0].Rows[0]["sl"].ToString();
                        //decimal zzhsbq = decimal.Parse(ViewData["zzhsbq"].ToString());
                        //ViewData["zzjebq"] = dszh.Tables[0].Rows.Count == 0 ? "0" : dszh.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zzjebq = decimal.Parse(ViewData["zzjebq"].ToString());

                        /////累计农行契税
                        //DataSet dsljqs = fwmmyhsrBll.CountListLjQs(yyyy, mm);

                        //ViewData["ljqshsbq"] = dsljqs.Tables[0].Rows.Count == 0 ? "0" : dsljqs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljqshsbq = decimal.Parse(ViewData["ljqshsbq"].ToString());
                        //ViewData["ljqsjebq"] = dsljqs.Tables[0].Rows.Count == 0 ? "0" : dsljqs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljqsjebq = decimal.Parse(ViewData["ljqsjebq"].ToString());

                        /////累计农行个人所得税
                        //DataSet dsljgrs = fwmmyhsrBll.CountListLjGrs(yyyy, mm);

                        //ViewData["ljgrhsbq"] = dsljgrs.Tables[0].Rows.Count == 0 ? "0" : dsljgrs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljgrhsbq = decimal.Parse(ViewData["ljgrhsbq"].ToString());
                        //ViewData["ljgrjebq"] = dsljgrs.Tables[0].Rows.Count == 0 ? "0" : dsljgrs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljgrjebq = decimal.Parse(ViewData["ljgrjebq"].ToString());

                        /////累计农行自住改善型
                        //DataSet dsljzh = fwmmyhsrBll.CountListLjZh(yyyy, mm);

                        //ViewData["ljzzhsbq"] = dsljzh.Tables[0].Rows.Count == 0 ? "0" : dsljzh.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljzzhsbq = decimal.Parse(ViewData["ljzzhsbq"].ToString());
                        //ViewData["ljzzjebq"] = dsljzh.Tables[0].Rows.Count == 0 ? "0" : dsljzh.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljzzjebq = decimal.Parse(ViewData["ljzzjebq"].ToString());

                        /////农行期初数
                        //DataSet dsqcsa = fwmmyhsrBll.CountListQcsa(yyyy, mm);
                        //ViewData["dsqcsa"] = dsqcsa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsa.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal a = decimal.Parse(ViewData["dsqcsa"].ToString());

                        //DataSet dsqcsb = fwmmyhsrBll.CountListQcsb(yyyy, mm);
                        //ViewData["dsqcsb"] = dsqcsb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal b = decimal.Parse(ViewData["dsqcsb"].ToString());

                        //DataSet dsqcsc = fwmmyhsrBll.CountListQcsc(yyyy, mm);
                        //ViewData["dsqcsc"] = dsqcsc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcsc.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal c = decimal.Parse(ViewData["dsqcsc"].ToString());

                        //decimal d = a + b - c;
                        //ViewData["dsqcsd"] = d;

                        /////农行本期收入
                        //DataSet dssr = fwmmyhsrBll.CountListBqsr(yyyy, mm);
                        //ViewData["dssr"] = dssr.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssr.Tables[0].Rows[0]["srje"].ToString();
                        //decimal sr = decimal.Parse(ViewData["dssr"].ToString());

                        /////农行本期支出
                        //DataSet dszc = fwmmyhsrBll.CountListBqzc(yyyy, mm);
                        //ViewData["dszc"] = dszc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszc.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zc = decimal.Parse(ViewData["dszc"].ToString());
                        /////余额
                        //decimal ye = d + sr - zc;
                        //ViewData["dsye"] = ye;


                        /////鄞州银行
                        /////本期鄞州银行契税
                        //DataSet ydsqs = fwmmyhsrBll.CountListYZQs(yyyy, mm);
                        //ViewData["yqshsbq"] = ydsqs.Tables[0].Rows.Count == 0 ? "0" : ydsqs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yqshsbq = decimal.Parse(ViewData["yqshsbq"].ToString());
                        //ViewData["yqsjebq"] = ydsqs.Tables[0].Rows.Count == 0 ? "0" : ydsqs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yqsjebq = decimal.Parse(ViewData["yqsjebq"].ToString());

                        /////本期鄞州银行个人所得税
                        //DataSet ydsgrs = fwmmyhsrBll.CountListYZGrs(yyyy, mm);

                        //ViewData["ygrhsbq"] = ydsgrs.Tables[0].Rows.Count == 0 ? "0" : ydsgrs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ygrhsbq = decimal.Parse(ViewData["ygrhsbq"].ToString());
                        //ViewData["ygrjebq"] = ydsgrs.Tables[0].Rows.Count == 0 ? "0" : ydsgrs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ygrjebq = decimal.Parse(ViewData["ygrjebq"].ToString());

                        /////本期鄞州银行自住改善型
                        //DataSet ydszh = fwmmyhsrBll.CountListYZZh(yyyy, mm);

                        //ViewData["yzzhsbq"] = ydszh.Tables[0].Rows.Count == 0 ? "0" : ydszh.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yzzhsbq = decimal.Parse(ViewData["yzzhsbq"].ToString());
                        //ViewData["yzzjebq"] = ydszh.Tables[0].Rows.Count == 0 ? "0" : ydszh.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzzjebq = decimal.Parse(ViewData["yzzjebq"].ToString());

                        /////累计鄞州银行契税
                        //DataSet ydsljqs = fwmmyhsrBll.CountListYZLjQs(yyyy, mm);

                        //ViewData["yljqshsbq"] = ydsljqs.Tables[0].Rows.Count == 0 ? "0" : ydsljqs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljqshsbq = decimal.Parse(ViewData["yljqshsbq"].ToString());
                        //ViewData["yljqsjebq"] = ydsljqs.Tables[0].Rows.Count == 0 ? "0" : ydsljqs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljqsjebq = decimal.Parse(ViewData["yljqsjebq"].ToString());
                        /////累计鄞州银行个人所得税

                        //DataSet ydsljgrs = fwmmyhsrBll.CountListYZLjGrs(yyyy, mm);
                        //ViewData["yljgrhsbq"] = ydsljgrs.Tables[0].Rows.Count == 0 ? "0" : ydsljgrs.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljgrhsbq = decimal.Parse(ViewData["yljgrhsbq"].ToString());
                        //ViewData["yljgrjebq"] = ydsljgrs.Tables[0].Rows.Count == 0 ? "0" : ydsljgrs.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljgrjebq = decimal.Parse(ViewData["yljgrjebq"].ToString());

                        /////累计鄞州银行自住改善型
                        //DataSet ydsljzh = fwmmyhsrBll.CountListYZLjZh(yyyy, mm);

                        //ViewData["yljzzhsbq"] = ydsljzh.Tables[0].Rows.Count == 0 ? "0" : ydsljzh.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljzzhsbq = decimal.Parse(ViewData["yljzzhsbq"].ToString());
                        //ViewData["yljzzjebq"] = ydsljzh.Tables[0].Rows.Count == 0 ? "0" : ydsljzh.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljzzjebq = decimal.Parse(ViewData["yljzzjebq"].ToString());

                        /////鄞州银行期初数
                        //DataSet ydsqcsa = fwmmyhsrBll.CountListYZQcsa(yyyy, mm);
                        //ViewData["ydsqcsa"] = ydsqcsa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsa.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal ya = decimal.Parse(ViewData["ydsqcsa"].ToString());

                        //DataSet ydsqcsb = fwmmyhsrBll.CountListYZQcsb(yyyy, mm);
                        //ViewData["ydsqcsb"] = ydsqcsb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal yb = decimal.Parse(ViewData["ydsqcsb"].ToString());

                        //DataSet ydsqcsc = fwmmyhsrBll.CountListYZQcsc(yyyy, mm);
                        //ViewData["ydsqcsc"] = ydsqcsc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcsc.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yc = decimal.Parse(ViewData["ydsqcsc"].ToString());

                        //decimal yd = ya + yb - yc;
                        //ViewData["ydsqcsd"] = yd;

                        /////鄞州银行本期收入
                        //DataSet ydssr = fwmmyhsrBll.CountListYZBqsr(yyyy, mm);
                        //ViewData["ydssr"] = ydssr.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssr.Tables[0].Rows[0]["srje"].ToString();
                        //decimal ysr = decimal.Parse(ViewData["ydssr"].ToString());

                        /////鄞州银行本期支出
                        //DataSet ydszc = fwmmyhsrBll.CountListYZBqzc(yyyy, mm);
                        //ViewData["ydszc"] = ydszc.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszc.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzc = decimal.Parse(ViewData["ydszc"].ToString());
                        /////余额
                        //decimal yye = yd + ysr - yzc;
                        //ViewData["ydsye"] = yye;

                        /////合计
                        //ViewData["hjbq"] = d + yd;
                        //ViewData["hjbqsr"] = sr + ysr;
                        //ViewData["hjbqzc"] = zc + yzc;
                        //ViewData["hjbqye"] = ye + yye;
                        //ViewData["hjqshsbq"] = qshsbq + yqshsbq;
                        //ViewData["hjqshslj"] = ljqshsbq + yljqshsbq;
                        //ViewData["hjqsjebq"] = qsjebq + yqsjebq;
                        //ViewData["hjqsjelj"] = ljqsjebq + yljqsjebq;
                        //ViewData["hjgrhsbq"] = grhsbq + ygrhsbq;
                        //ViewData["hjgrhslj"] = ljgrhsbq + yljgrhsbq;
                        //ViewData["hjgrjebq"] = grjebq + ygrjebq;
                        //ViewData["hjgrjelj"] = ljgrjebq + yljgrjebq;
                        //ViewData["hjzzhsbq"] = zzhsbq + yzzhsbq;
                        //ViewData["hjzzhslj"] = ljzzhsbq + yljzzhsbq;
                        //ViewData["hjzzjebq"] = zzjebq + yzzjebq;
                        //ViewData["hjzzjelj"] = ljzzjebq + yljzzjebq;


                        /////第二个表                   
                        /////农行期初数
                        //DataSet dsqcsaa = fwmmyhsrBll.CountListQcsa(yyyy, mm);
                        //ViewData["dsqcsaa"] = dsqcsaa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsaa.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal aa = decimal.Parse(ViewData["dsqcsaa"].ToString());

                        //DataSet dsqcsba = fwmmyhsrBll.GetQcsta(yyyy, mm);
                        //ViewData["dsqcsba"] = dsqcsba.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsba.Tables[0].Rows[0]["srje"].ToString();
                        //decimal ba = decimal.Parse(ViewData["dsqcsba"].ToString());

                        //DataSet dsqcsca = fwmmyhsrBll.GetQcstb(yyyy, mm);
                        //ViewData["dsqcsca"] = dsqcsca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcsca.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ca = decimal.Parse(ViewData["dsqcsca"].ToString());

                        //decimal da = aa + ba - ca;
                        //ViewData["dsqcsda"] = da;

                        /////农行本期收入
                        //DataSet dssra = fwmmyhsrBll.GetBqsr(yyyy, mm, sjrq2);
                        //ViewData["dssra"] = dssra.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssra.Tables[0].Rows[0]["srje"].ToString();
                        //decimal sra = decimal.Parse(ViewData["dssra"].ToString());

                        /////农行本期支出
                        //DataSet dszca = fwmmyhsrBll.GetBqzc(yyyy, mm, sjrq2);
                        //ViewData["dszca"] = dszca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszca.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zca = decimal.Parse(ViewData["dszca"].ToString());
                        /////余额
                        //decimal yea = da + sra - zca;
                        //ViewData["dsyea"] = yea;


                        /////本期农行契税
                        //DataSet dsqsa = fwmmyhsrBll.Getbqqsa(yyyy, mm, sjrq2);
                        //ViewData["qshsbqa"] = dsqsa.Tables[0].Rows.Count == 0 ? "0" : dsqsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal qshsbqa = decimal.Parse(ViewData["qshsbqa"].ToString());
                        //ViewData["qsjebqa"] = dsqsa.Tables[0].Rows.Count == 0 ? "0" : dsqsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal qsjebqa = decimal.Parse(ViewData["qsjebqa"].ToString());

                        /////累计农行契税
                        //DataSet dsljqsa = fwmmyhsrBll.Getljqsa(yyyy, mm, sjrq2);
                        //ViewData["ljqshsbqa"] = dsljqsa.Tables[0].Rows.Count == 0 ? "0" : dsljqsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljqshsbqa = decimal.Parse(ViewData["ljqshsbqa"].ToString());
                        //ViewData["ljqsjebqa"] = dsljqsa.Tables[0].Rows.Count == 0 ? "0" : dsljqsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljqsjebqa = decimal.Parse(ViewData["ljqsjebqa"].ToString());

                        /////本期农行个人所得税
                        //DataSet dsgrsa = fwmmyhsrBll.GetGrsa(yyyy, mm, sjrq2);
                        //ViewData["grhsbqa"] = dsgrsa.Tables[0].Rows.Count == 0 ? "0" : dsgrsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal grhsbqa = decimal.Parse(ViewData["grhsbqa"].ToString());
                        //ViewData["grjebqa"] = dsgrsa.Tables[0].Rows.Count == 0 ? "0" : dsgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal grjebqa = decimal.Parse(ViewData["grjebqa"].ToString());

                        /////累计农行个人所得税
                        //DataSet dsljgrsa = fwmmyhsrBll.GetLjGrsa(yyyy, mm, sjrq2);
                        //ViewData["ljgrhsbqa"] = dsljgrsa.Tables[0].Rows.Count == 0 ? "0" : dsljgrsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljgrhsbqa = decimal.Parse(ViewData["ljgrhsbq"].ToString());
                        //ViewData["ljgrjebqa"] = dsljgrsa.Tables[0].Rows.Count == 0 ? "0" : dsljgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljgrjebqa = decimal.Parse(ViewData["ljgrjebq"].ToString());

                        /////本期农行自住改善型
                        //DataSet dszha = fwmmyhsrBll.GetZha(yyyy, mm, sjrq2);

                        //ViewData["zzhsbqa"] = dszha.Tables[0].Rows.Count == 0 ? "0" : dszha.Tables[0].Rows[0]["sl"].ToString();
                        //decimal zzhsbqa = decimal.Parse(ViewData["zzhsbqa"].ToString());
                        //ViewData["zzjebqa"] = dszha.Tables[0].Rows.Count == 0 ? "0" : dszha.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zzjebqa = decimal.Parse(ViewData["zzjebqa"].ToString());

                        /////累计农行自住改善型
                        //DataSet dsljzha = fwmmyhsrBll.GetLjZha(yyyy, mm, sjrq2);
                        //ViewData["ljzzhsbqa"] = dsljzha.Tables[0].Rows.Count == 0 ? "0" : dsljzha.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljzzhsbqa = decimal.Parse(ViewData["ljzzhsbqa"].ToString());
                        //ViewData["ljzzjebqa"] = dsljzha.Tables[0].Rows.Count == 0 ? "0" : dsljzha.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljzzjebqa = decimal.Parse(ViewData["ljzzjebqa"].ToString());

                        /////鄞州银行
                        /////鄞州银行期初数
                        //DataSet ydsqcsaa = fwmmyhsrBll.CountListYZQcsa(yyyy, mm);
                        //ViewData["ydsqcsaa"] = ydsqcsaa.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsaa.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal yaa = decimal.Parse(ViewData["ydsqcsaa"].ToString());

                        //DataSet ydsqcsba = fwmmyhsrBll.GetYZQcsta(yyyy, mm);
                        //ViewData["ydsqcsba"] = ydsqcsba.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsba.Tables[0].Rows[0]["srje"].ToString();
                        //decimal yba = decimal.Parse(ViewData["ydsqcsba"].ToString());

                        //DataSet ydsqcsca = fwmmyhsrBll.GetYZQcstb(yyyy, mm);
                        //ViewData["ydsqcsca"] = ydsqcsca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcsca.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yca = decimal.Parse(ViewData["ydsqcsca"].ToString());

                        //decimal yda = yaa + yba - yca;
                        //ViewData["ydsqcsda"] = yda;

                        /////鄞州银行本期收入
                        //DataSet ydssra = fwmmyhsrBll.GetYZBqsr(yyyy, mm, sjrq2);
                        //ViewData["ydssra"] = ydssra.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssra.Tables[0].Rows[0]["srje"].ToString();
                        //decimal ysra = decimal.Parse(ViewData["ydssra"].ToString());

                        /////鄞州银行本期支出
                        //DataSet ydszca = fwmmyhsrBll.GetYZBqzc(yyyy, mm, sjrq2);
                        //ViewData["ydszca"] = ydszca.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszca.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzca = decimal.Parse(ViewData["ydszca"].ToString());
                        /////余额
                        //decimal yyea = yda + ysra - yzca;
                        //ViewData["ydsyea"] = yyea;


                        /////本期农行契税
                        //DataSet ydsqsa = fwmmyhsrBll.GetYZbqqsa(yyyy, mm, sjrq2);
                        //ViewData["yqshsbqa"] = ydsqsa.Tables[0].Rows.Count == 0 ? "0" : ydsqsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yqshsbqa = decimal.Parse(ViewData["yqshsbqa"].ToString());
                        //ViewData["yqsjebqa"] = ydsqsa.Tables[0].Rows.Count == 0 ? "0" : ydsqsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yqsjebqa = decimal.Parse(ViewData["yqsjebqa"].ToString());

                        /////累计农行契税
                        //DataSet ydsljqsa = fwmmyhsrBll.GetYZljqsa(yyyy, mm, sjrq2);
                        //ViewData["yljqshsbqa"] = ydsljqsa.Tables[0].Rows.Count == 0 ? "0" : ydsljqsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljqshsbqa = decimal.Parse(ViewData["yljqshsbqa"].ToString());
                        //ViewData["yljqsjebqa"] = ydsljqsa.Tables[0].Rows.Count == 0 ? "0" : ydsljqsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljqsjebqa = decimal.Parse(ViewData["yljqsjebqa"].ToString());

                        /////本期农行个人所得税
                        //DataSet ydsgrsa = fwmmyhsrBll.GetYZGrsa(yyyy, mm, sjrq2);
                        //ViewData["ygrhsbqa"] = ydsgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsgrsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ygrhsbqa = decimal.Parse(ViewData["ygrhsbqa"].ToString());
                        //ViewData["ygrjebqa"] = ydsgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ygrjebqa = decimal.Parse(ViewData["ygrjebqa"].ToString());

                        /////累计农行个人所得税
                        //DataSet ydsljgrsa = fwmmyhsrBll.GetYZLjGrsa(yyyy, mm, sjrq2);
                        //ViewData["yljgrhsbqa"] = ydsljgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsa.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljgrhsbqa = decimal.Parse(ViewData["yljgrhsbqa"].ToString());
                        //ViewData["yljgrjebqa"] = ydsljgrsa.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljgrjebqa = decimal.Parse(ViewData["yljgrjebqa"].ToString());

                        /////本期农行自住改善型
                        //DataSet ydszha = fwmmyhsrBll.GetYZZha(yyyy, mm, sjrq2);

                        //ViewData["yzzhsbqa"] = ydszha.Tables[0].Rows.Count == 0 ? "0" : ydszha.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yzzhsbqa = decimal.Parse(ViewData["yzzhsbqa"].ToString());
                        //ViewData["yzzjebqa"] = ydszha.Tables[0].Rows.Count == 0 ? "0" : ydszha.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzzjebqa = decimal.Parse(ViewData["yzzjebqa"].ToString());

                        /////累计农行自住改善型
                        //DataSet ydsljzha = fwmmyhsrBll.GetYZLjZha(yyyy, mm, sjrq2);
                        //ViewData["yljzzhsbqa"] = ydsljzha.Tables[0].Rows.Count == 0 ? "0" : ydsljzha.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljzzhsbqa = decimal.Parse(ViewData["yljzzhsbqa"].ToString());
                        //ViewData["yljzzjebqa"] = ydsljzha.Tables[0].Rows.Count == 0 ? "0" : ydsljzha.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljzzjebqa = decimal.Parse(ViewData["yljzzjebqa"].ToString());

                        /////合计
                        //ViewData["hjbqa"] = da + yda;
                        //ViewData["hjbqsra"] = sra + ysra;
                        //ViewData["hjbqzca"] = zca + yzca;
                        //ViewData["hjbqyea"] = yea + yyea;
                        //ViewData["hjqshsbqa"] = qshsbqa + yqshsbqa;
                        //ViewData["hjqshslja"] = ljqshsbqa + yljqshsbqa;
                        //ViewData["hjqsjebqa"] = qsjebqa + yqsjebqa;
                        //ViewData["hjqsjelja"] = ljqsjebqa + yljqsjebqa;
                        //ViewData["hjgrhsbqa"] = grhsbqa + ygrhsbqa;
                        //ViewData["hjgrhslja"] = ljgrhsbqa + yljgrhsbqa;
                        //ViewData["hjgrjebqa"] = grjebqa + ygrjebqa;
                        //ViewData["hjgrjelja"] = ljgrjebqa + yljgrjebqa;
                        //ViewData["hjzzhsbqa"] = zzhsbqa + yzzhsbqa;
                        //ViewData["hjzzhslja"] = ljzzhsbqa + yljzzhsbqa;
                        //ViewData["hjzzjebqa"] = zzjebqa + yzzjebqa;
                        //ViewData["hjzzjelja"] = ljzzjebqa + yljzzjebqa;

                        /////第3个表
                        /////农行期初数
                        //DataSet dsqcsab = rcBll.CountListQcsa(yyyy, mm);
                        //ViewData["dsqcsab"] = dsqcsab.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : dsqcsab.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal ab = decimal.Parse(ViewData["dsqcsab"].ToString());

                        //DataSet dsqcsbb = rcBll.GetQcsta(sjrq5);
                        //ViewData["dsqcsbb"] = dsqcsbb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dsqcsbb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal bb = decimal.Parse(ViewData["dsqcsbb"].ToString());

                        //DataSet dsqcscb = rcBll.GetQcstb(sjrq5);
                        //ViewData["dsqcscb"] = dsqcscb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dsqcscb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal cb = decimal.Parse(ViewData["dsqcscb"].ToString());

                        //decimal db = ab + bb - cb;
                        //ViewData["dsqcsdb"] = db;

                        /////农行本期收入
                        //DataSet dssrb = rcBll.GetBqsr(yyyy, mm, sjrq5);
                        //ViewData["dssrb"] = dssrb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : dssrb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal srb = decimal.Parse(ViewData["dssrb"].ToString());

                        /////农行本期支出
                        //DataSet dszcb = rcBll.GetBqzc(yyyy, mm, sjrq5);
                        //ViewData["dszcb"] = dszcb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : dszcb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zcb = decimal.Parse(ViewData["dszcb"].ToString());
                        /////余额
                        //decimal yeb = db + srb - zcb;
                        //ViewData["dsyeb"] = yeb;


                        /////本期农行契税
                        //DataSet dsqsb = rcBll.Getbqqsa(yyyy, mm, sjrq5);
                        //ViewData["qshsbqb"] = dsqsb.Tables[0].Rows.Count == 0 ? "0" : dsqsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal qshsbqb = decimal.Parse(ViewData["qshsbqb"].ToString());
                        //ViewData["qsjebqb"] = dsqsa.Tables[0].Rows.Count == 0 ? "0" : dsqsa.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal qsjebqb = decimal.Parse(ViewData["qsjebqb"].ToString());

                        /////累计农行契税
                        //DataSet dsljqsb = rcBll.Getljqsa(yyyy, mm, sjrq5);
                        //ViewData["ljqshsbqb"] = dsljqsb.Tables[0].Rows.Count == 0 ? "0" : dsljqsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljqshsbqb = decimal.Parse(ViewData["ljqshsbqb"].ToString());
                        //ViewData["ljqsjebqb"] = dsljqsb.Tables[0].Rows.Count == 0 ? "0" : dsljqsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljqsjebqb = decimal.Parse(ViewData["ljqsjebqb"].ToString());

                        /////本期农行个人所得税
                        //DataSet dsgrsb = rcBll.GetGrsa(yyyy, mm, sjrq5);
                        //ViewData["grhsbqb"] = dsgrsb.Tables[0].Rows.Count == 0 ? "0" : dsgrsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal grhsbqb = decimal.Parse(ViewData["grhsbqb"].ToString());
                        //ViewData["grjebqb"] = dsgrsb.Tables[0].Rows.Count == 0 ? "0" : dsgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal grjebqb = decimal.Parse(ViewData["grjebqb"].ToString());

                        /////累计农行个人所得税
                        //DataSet dsljgrsb = rcBll.GetLjGrsa(yyyy, mm, sjrq5);
                        //ViewData["ljgrhsbqb"] = dsljgrsb.Tables[0].Rows.Count == 0 ? "0" : dsljgrsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljgrhsbqb = decimal.Parse(ViewData["ljgrhsbqb"].ToString());
                        //ViewData["ljgrjebqb"] = dsljgrsb.Tables[0].Rows.Count == 0 ? "0" : dsljgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljgrjebqb = decimal.Parse(ViewData["ljgrjebqb"].ToString());

                        /////本期农行自住改善型
                        //DataSet dszhb = rcBll.GetZha(yyyy, mm, sjrq5);

                        //ViewData["zzhsbqb"] = dszhb.Tables[0].Rows.Count == 0 ? "0" : dszhb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal zzhsbqb = decimal.Parse(ViewData["zzhsbqb"].ToString());
                        //ViewData["zzjebqb"] = dszhb.Tables[0].Rows.Count == 0 ? "0" : dszhb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal zzjebqb = decimal.Parse(ViewData["zzjebqb"].ToString());

                        /////累计农行自住改善型
                        //DataSet dsljzhb = rcBll.GetLjZha(yyyy, mm, sjrq5);
                        //ViewData["ljzzhsbqb"] = dsljzhb.Tables[0].Rows.Count == 0 ? "0" : dsljzhb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ljzzhsbqb = decimal.Parse(ViewData["ljzzhsbqb"].ToString());
                        //ViewData["ljzzjebqb"] = dsljzhb.Tables[0].Rows.Count == 0 ? "0" : dsljzhb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ljzzjebqb = decimal.Parse(ViewData["ljzzjebqb"].ToString());

                        /////鄞州银行
                        /////鄞州银行期初数
                        //DataSet ydsqcsab = rcBll.CountListYZQcsa(yyyy, mm);
                        //ViewData["ydsqcsab"] = ydsqcsab.Tables[0].Rows[0]["ncs"].ToString() == "" ? "0" : ydsqcsab.Tables[0].Rows[0]["ncs"].ToString();
                        //decimal yab = decimal.Parse(ViewData["ydsqcsab"].ToString());

                        //DataSet ydsqcsbb = rcBll.GetYZQcsta(sjrq5);
                        //ViewData["ydsqcsbb"] = ydsqcsbb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydsqcsbb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal ybb = decimal.Parse(ViewData["ydsqcsbb"].ToString());

                        //DataSet ydsqcscb = rcBll.GetYZQcstb(sjrq5);
                        //ViewData["ydsqcscb"] = ydsqcscb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydsqcscb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ycb = decimal.Parse(ViewData["ydsqcscb"].ToString());

                        //decimal ydb = yab + ybb - ycb;
                        //ViewData["ydsqcsdb"] = ydb;

                        /////鄞州银行本期收入
                        //DataSet ydssrb = rcBll.GetYZBqsr(yyyy, mm, sjrq5);
                        //ViewData["ydssrb"] = ydssrb.Tables[0].Rows[0]["srje"].ToString() == "" ? "0" : ydssrb.Tables[0].Rows[0]["srje"].ToString();
                        //decimal ysrb = decimal.Parse(ViewData["ydssrb"].ToString());

                        /////鄞州银行本期支出
                        //DataSet ydszcb = rcBll.GetYZBqzc(yyyy, mm, sjrq5);
                        //ViewData["ydszcb"] = ydszcb.Tables[0].Rows[0]["ybtse"].ToString() == "" ? "0" : ydszcb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzcb = decimal.Parse(ViewData["ydszcb"].ToString());
                        /////余额
                        //decimal yyeb = ydb + ysrb - yzcb;
                        //ViewData["ydsyeb"] = yyeb;


                        /////本期鄞州银行契税
                        //DataSet ydsqsb = rcBll.GetYZbqqsa(yyyy, mm, sjrq5);
                        //ViewData["yqshsbqb"] = ydsqsb.Tables[0].Rows.Count == 0 ? "0" : ydsqsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yqshsbqb = decimal.Parse(ViewData["yqshsbqb"].ToString());
                        //ViewData["yqsjebqb"] = ydsqsb.Tables[0].Rows.Count == 0 ? "0" : ydsqsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yqsjebqb = decimal.Parse(ViewData["yqsjebqb"].ToString());

                        /////累计农行契税
                        //DataSet ydsljqsb = rcBll.GetYZljqsa(yyyy, mm, sjrq5);
                        //ViewData["yljqshsbqb"] = ydsljqsb.Tables[0].Rows.Count == 0 ? "0" : ydsljqsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljqshsbqb = decimal.Parse(ViewData["yljqshsbqb"].ToString());
                        //ViewData["yljqsjebqb"] = ydsljqsb.Tables[0].Rows.Count == 0 ? "0" : ydsljqsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljqsjebqb = decimal.Parse(ViewData["yljqsjebqb"].ToString());

                        /////本期鄞州银行个人所得税
                        //DataSet ydsgrsb = rcBll.GetYZGrsa(yyyy, mm, sjrq5);
                        //ViewData["ygrhsbqb"] = ydsgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsgrsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal ygrhsbqb = decimal.Parse(ViewData["ygrhsbqb"].ToString());
                        //ViewData["ygrjebqb"] = ydsgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal ygrjebqb = decimal.Parse(ViewData["ygrjebqb"].ToString());

                        /////累计鄞州银行个人所得税
                        //DataSet ydsljgrsb = rcBll.GetYZLjGrsa(yyyy, mm, sjrq5);
                        //ViewData["yljgrhsbqb"] = ydsljgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljgrhsbqb = decimal.Parse(ViewData["yljgrhsbqb"].ToString());
                        //ViewData["yljgrjebqb"] = ydsljgrsb.Tables[0].Rows.Count == 0 ? "0" : ydsljgrsb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljgrjebqb = decimal.Parse(ViewData["yljgrjebqb"].ToString());

                        /////本期鄞州银行自住改善型
                        //DataSet ydszhb = rcBll.GetYZZha(yyyy, mm, sjrq2);

                        //ViewData["yzzhsbqb"] = ydszhb.Tables[0].Rows.Count == 0 ? "0" : ydszhb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yzzhsbqb = decimal.Parse(ViewData["yzzhsbqb"].ToString());
                        //ViewData["yzzjebqb"] = ydszhb.Tables[0].Rows.Count == 0 ? "0" : ydszhb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yzzjebqb = decimal.Parse(ViewData["yzzjebqb"].ToString());

                        /////累计鄞州银行自住改善型
                        //DataSet ydsljzhb = rcBll.GetYZLjZha(yyyy, mm, sjrq5);
                        //ViewData["yljzzhsbqb"] = ydsljzhb.Tables[0].Rows.Count == 0 ? "0" : ydsljzhb.Tables[0].Rows[0]["sl"].ToString();
                        //decimal yljzzhsbqb = decimal.Parse(ViewData["yljzzhsbqb"].ToString());
                        //ViewData["yljzzjebqb"] = ydsljzhb.Tables[0].Rows.Count == 0 ? "0" : ydsljzhb.Tables[0].Rows[0]["ybtse"].ToString();
                        //decimal yljzzjebqb = decimal.Parse(ViewData["yljzzjebqb"].ToString());

                        /////合计
                        //ViewData["hjbqb"] = db + ydb;
                        //ViewData["hjbqsrb"] = srb + ysrb;
                        //ViewData["hjbqzcb"] = zcb + yzcb;
                        //ViewData["hjbqyeb"] = yeb + yyeb;
                        //ViewData["hjqshsbqb"] = qshsbqb + yqshsbqb;
                        //ViewData["hjqshsljb"] = ljqshsbqb + yljqshsbqb;
                        //ViewData["hjqsjebqb"] = qsjebqb + yqsjebqb;
                        //ViewData["hjqsjeljb"] = ljqsjebqb + yljqsjebqb;
                        //ViewData["hjgrhsbqb"] = grhsbqb + ygrhsbqb;
                        //ViewData["hjgrhsljb"] = ljgrhsbqb + yljgrhsbqb;
                        //ViewData["hjgrjebqb"] = grjebqb + ygrjebqb;
                        //ViewData["hjgrjeljb"] = ljgrjebqb + yljgrjebqb;
                        //ViewData["hjzzhsbqb"] = zzhsbqb + yzzhsbqb;
                        //ViewData["hjzzhsljb"] = ljzzhsbqb + yljzzhsbqb;
                        //ViewData["hjzzjebqb"] = zzjebqb + yzzjebqb;
                        //ViewData["hjzzjeljb"] = ljzzjebqb + yljzzjebqb;


                        //DataSet ds = new DataSet();
                        //DataTable dt = new DataTable();

                        //dt.Columns.Add("dsqcsd");
                        //dt.Columns.Add("dssr");
                        //dt.Columns.Add("dszc");
                        //dt.Columns.Add("dsye");
                        //dt.Columns.Add("qshsbq");
                        //dt.Columns.Add("ljqshsbq");
                        //dt.Columns.Add("qsjebq");
                        //dt.Columns.Add("ljqsjebq");
                        //dt.Columns.Add("grhsbq");
                        //dt.Columns.Add("ljgrhsbq");
                        //dt.Columns.Add("grjebq");
                        //dt.Columns.Add("ljgrjebq");
                        //dt.Columns.Add("zzhsbq");
                        //dt.Columns.Add("ljzzhsbq");
                        //dt.Columns.Add("zzjebq");
                        //dt.Columns.Add("ljzzjebq");

                        //dt.Columns.Add("ydsqcsd");
                        //dt.Columns.Add("ydssr");
                        //dt.Columns.Add("ydszc");
                        //dt.Columns.Add("ydsye");
                        //dt.Columns.Add("yqshsbq");
                        //dt.Columns.Add("yljqshsbq");
                        //dt.Columns.Add("yqsjebq");
                        //dt.Columns.Add("yljqsjebq");
                        //dt.Columns.Add("ygrhsbq");
                        //dt.Columns.Add("yljgrhsbq");
                        //dt.Columns.Add("ygrjebq");
                        //dt.Columns.Add("yljgrjebq");
                        //dt.Columns.Add("yzzhsbq");
                        //dt.Columns.Add("yljzzhsbq");
                        //dt.Columns.Add("yzzjebq");
                        //dt.Columns.Add("yljzzjebq");

                        //dt.Columns.Add("hjbq");
                        //dt.Columns.Add("hjbqsr");
                        //dt.Columns.Add("hjbqzc");
                        //dt.Columns.Add("hjbqye");
                        //dt.Columns.Add("hjqshsbq");
                        //dt.Columns.Add("hjqshslj");
                        //dt.Columns.Add("hjqsjebq");
                        //dt.Columns.Add("hjqsjelj");
                        //dt.Columns.Add("hjgrhsbq");
                        //dt.Columns.Add("hjgrhslj");
                        //dt.Columns.Add("hjgrjebq");
                        //dt.Columns.Add("hjgrjelj");
                        //dt.Columns.Add("hjzzhsbq");
                        //dt.Columns.Add("hjzzhslj");
                        //dt.Columns.Add("hjzzjebq");
                        //dt.Columns.Add("hjzzjelj");

                        //dt.Columns.Add("dsqcsda");
                        //dt.Columns.Add("dssra");
                        //dt.Columns.Add("dszca");
                        //dt.Columns.Add("dsyea");
                        //dt.Columns.Add("qshsbqa");
                        //dt.Columns.Add("ljqshsbqa");
                        //dt.Columns.Add("qsjebqa");
                        //dt.Columns.Add("ljqsjebqa");
                        //dt.Columns.Add("grhsbqa");
                        //dt.Columns.Add("ljgrhsbqa");
                        //dt.Columns.Add("grjebqa");
                        //dt.Columns.Add("ljgrjebqa");
                        //dt.Columns.Add("zzhsbqa");
                        //dt.Columns.Add("ljzzhsbqa");
                        //dt.Columns.Add("zzjebqa");
                        //dt.Columns.Add("ljzzjebqa");

                        //dt.Columns.Add("ydsqcsda");
                        //dt.Columns.Add("ydssra");
                        //dt.Columns.Add("ydszca");
                        //dt.Columns.Add("ydsyea");
                        //dt.Columns.Add("yqshsbqa");
                        //dt.Columns.Add("yljqshsbqa");
                        //dt.Columns.Add("yqsjebqa");
                        //dt.Columns.Add("yljqsjebqa");
                        //dt.Columns.Add("ygrhsbqa");
                        //dt.Columns.Add("yljgrhsbqa");
                        //dt.Columns.Add("ygrjebqa");
                        //dt.Columns.Add("yljgrjebqa");
                        //dt.Columns.Add("yzzhsbqa");
                        //dt.Columns.Add("yljzzhsbqa");
                        //dt.Columns.Add("yzzjebqa");
                        //dt.Columns.Add("yljzzjebqa");

                        //dt.Columns.Add("hjbqa");
                        //dt.Columns.Add("hjbqsra");
                        //dt.Columns.Add("hjbqzca");
                        //dt.Columns.Add("hjbqyea");
                        //dt.Columns.Add("hjqshsbqa");
                        //dt.Columns.Add("hjqshslja");
                        //dt.Columns.Add("hjqsjebqa");
                        //dt.Columns.Add("hjqsjelja");
                        //dt.Columns.Add("hjgrhsbqa");
                        //dt.Columns.Add("hjgrhslja");
                        //dt.Columns.Add("hjgrjebqa");
                        //dt.Columns.Add("hjgrjelja");
                        //dt.Columns.Add("hjzzhsbqa");
                        //dt.Columns.Add("hjzzhslja");
                        //dt.Columns.Add("hjzzjebqa");
                        //dt.Columns.Add("hjzzjelja");

                        //dt.Columns.Add("dsqcsdb");
                        //dt.Columns.Add("dssrb");
                        //dt.Columns.Add("dszcb");
                        //dt.Columns.Add("dsyeb");
                        //dt.Columns.Add("qshsbqb");
                        //dt.Columns.Add("ljqshsbqb");
                        //dt.Columns.Add("qsjebqb");
                        //dt.Columns.Add("ljqsjebqb");
                        //dt.Columns.Add("grhsbqb");
                        //dt.Columns.Add("ljgrhsbqb");
                        //dt.Columns.Add("grjebqb");
                        //dt.Columns.Add("ljgrjebqb");
                        //dt.Columns.Add("zzhsbqb");
                        //dt.Columns.Add("ljzzhsbqb");
                        //dt.Columns.Add("zzjebqb");
                        //dt.Columns.Add("ljzzjebqb");

                        //dt.Columns.Add("ydsqcsdb");
                        //dt.Columns.Add("ydssrb");
                        //dt.Columns.Add("ydszcb");
                        //dt.Columns.Add("ydsyeb");
                        //dt.Columns.Add("yqshsbqb");
                        //dt.Columns.Add("yljqshsbqb");
                        //dt.Columns.Add("yqsjebqb");
                        //dt.Columns.Add("yljqsjebqb");
                        //dt.Columns.Add("ygrhsbqb");
                        //dt.Columns.Add("yljgrhsbqb");
                        //dt.Columns.Add("ygrjebqb");
                        //dt.Columns.Add("yljgrjebqb");
                        //dt.Columns.Add("yzzhsbqb");
                        //dt.Columns.Add("yljzzhsbqb");
                        //dt.Columns.Add("yzzjebqb");
                        //dt.Columns.Add("yljzzjebqb");

                        //dt.Columns.Add("hjbqb");
                        //dt.Columns.Add("hjbqsrb");
                        //dt.Columns.Add("hjbqzcb");
                        //dt.Columns.Add("hjbqyeb");
                        //dt.Columns.Add("hjqshsbqb");
                        //dt.Columns.Add("hjqshsljb");
                        //dt.Columns.Add("hjqsjebqb");
                        //dt.Columns.Add("hjqsjeljb");
                        //dt.Columns.Add("hjgrhsbqb");
                        //dt.Columns.Add("hjgrhsljb");
                        //dt.Columns.Add("hjgrjebqb");
                        //dt.Columns.Add("hjgrjeljb");
                        //dt.Columns.Add("hjzzhsbqb");
                        //dt.Columns.Add("hjzzhsljb");
                        //dt.Columns.Add("hjzzjebqb");
                        //dt.Columns.Add("hjzzjeljb");

                        //dt.Columns.Add("年");
                        //dt.Columns.Add("月1");
                        //dt.Columns.Add("月2");


                        //DataRow dr = dt.NewRow();

                        //dr["dsqcsd"] = d;
                        //dr["dssr"] = sr;
                        //dr["dszc"] = zc;
                        //dr["dsye"] = ye;
                        //dr["qshsbq"] = qshsbq;
                        //dr["ljqshsbq"] = ljqshsbq;
                        //dr["qsjebq"] = qsjebq;
                        //dr["ljqsjebq"] = ljqsjebq;
                        //dr["grhsbq"] = grhsbq;
                        //dr["ljgrhsbq"] = ljgrhsbq;
                        //dr["grjebq"] = grjebq;
                        //dr["ljgrjebq"] = ljgrjebq;
                        //dr["zzhsbq"] = zzhsbq;
                        //dr["ljzzhsbq"] = ljzzhsbq;
                        //dr["zzjebq"] = zzjebq;
                        //dr["ljzzjebq"] = ljzzjebq;

                        //dr["ydsqcsd"] = yd;
                        //dr["ydssr"] = ysr;
                        //dr["ydszc"] = yzc;
                        //dr["ydsye"] = yye;
                        //dr["yqshsbq"] = yqshsbq;
                        //dr["yljqshsbq"] = yljqshsbq;
                        //dr["yqsjebq"] = yqsjebq;
                        //dr["yljqsjebq"] = yljqsjebq;
                        //dr["ygrhsbq"] = ygrhsbq;
                        //dr["yljgrhsbq"] = yljgrhsbq;
                        //dr["ygrjebq"] = ygrjebq;
                        //dr["yljgrjebq"] = yljgrjebq;
                        //dr["yzzhsbq"] = yzzhsbq;
                        //dr["yljzzhsbq"] = yljzzhsbq;
                        //dr["yzzjebq"] = yzzjebq;
                        //dr["yljzzjebq"] = yljzzjebq;

                        //dr["hjbq"] = d + yd;
                        //dr["hjbqsr"] = sr + ysr;
                        //dr["hjbqzc"] = zc + yzc;
                        //dr["hjbqye"] = ye + yye;
                        //dr["hjqshsbq"] = qshsbq + yqshsbq;
                        //dr["hjqshslj"] = ljqshsbq + yljqshsbq;
                        //dr["hjqsjebq"] = qsjebq + yqsjebq;
                        //dr["hjqsjelj"] = ljqsjebq + yljqsjebq;
                        //dr["hjgrhsbq"] = grhsbq + ygrhsbq;
                        //dr["hjgrhslj"] = ljgrhsbq + yljgrhsbq;
                        //dr["hjgrjebq"] = grjebq + ygrjebq;
                        //dr["hjgrjelj"] = ljgrjebq + yljgrjebq;
                        //dr["hjzzhsbq"] = zzhsbq + yzzhsbq;
                        //dr["hjzzhslj"] = ljzzhsbq + yljzzhsbq;
                        //dr["hjzzjebq"] = zzjebq + yzzjebq;
                        //dr["hjzzjelj"] = ljzzjebq + yljzzjebq;

                        //dr["dsqcsda"] = da;
                        //dr["dssra"] = sra;
                        //dr["dszca"] = zca;
                        //dr["dsyea"] = yea;
                        //dr["qshsbqa"] = qshsbqa;
                        //dr["ljqshsbqa"] = ljqshsbqa;
                        //dr["qsjebqa"] = qsjebqa;
                        //dr["ljqsjebqa"] = ljqsjebqa;
                        //dr["grhsbqa"] = grhsbqa;
                        //dr["ljgrhsbqa"] = ljgrhsbqa;
                        //dr["grjebqa"] = grjebqa;
                        //dr["ljgrjebqa"] = ljgrjebqa;
                        //dr["zzhsbqa"] = zzhsbqa;
                        //dr["ljzzhsbqa"] = ljzzhsbqa;
                        //dr["zzjebqa"] = zzjebqa;
                        //dr["ljzzjebqa"] = ljzzjebqa;

                        //dr["ydsqcsda"] = yda;
                        //dr["ydssra"] = ysra;
                        //dr["ydszca"] = yzca;
                        //dr["ydsyea"] = yyea;
                        //dr["yqshsbqa"] = yqshsbqa;
                        //dr["yljqshsbqa"] = yljqshsbqa;
                        //dr["yqsjebqa"] = yqsjebqa;
                        //dr["yljqsjebqa"] = yljqsjebqa;
                        //dr["ygrhsbqa"] = ygrhsbqa;
                        //dr["yljgrhsbqa"] = yljgrhsbqa;
                        //dr["ygrjebqa"] = ygrjebqa;
                        //dr["yljgrjebqa"] = yljgrjebqa;
                        //dr["yzzhsbqa"] = yzzhsbqa;
                        //dr["yljzzhsbqa"] = yljzzhsbqa;
                        //dr["yzzjebqa"] = yzzjebqa;
                        //dr["yljzzjebqa"] = yljzzjebqa;

                        //dr["hjbqa"] = da + yda;
                        //dr["hjbqsra"] = sra + ysra;
                        //dr["hjbqzca"] = zca + yzca;
                        //dr["hjbqyea"] = yea + yyea;
                        //dr["hjqshsbqa"] = qshsbqa + yqshsbqa;
                        //dr["hjqshslja"] = ljqshsbqa + yljqshsbqa;
                        //dr["hjqsjebqa"] = qsjebqa + yqsjebqa;
                        //dr["hjqsjelja"] = ljqsjebqa + yljqsjebqa;
                        //dr["hjgrhsbqa"] = grhsbqa + ygrhsbqa;
                        //dr["hjgrhslja"] = ljgrhsbqa + yljgrhsbqa;
                        //dr["hjgrjebqa"] = grjebqa + ygrjebqa;
                        //dr["hjgrjelja"] = ljgrjebqa + yljgrjebqa;
                        //dr["hjzzhsbqa"] = zzhsbqa + yzzhsbqa;
                        //dr["hjzzhslja"] = ljzzhsbqa + yljzzhsbqa;
                        //dr["hjzzjebqa"] = zzjebqa + yzzjebqa;
                        //dr["hjzzjelja"] = ljzzjebqa + yljzzjebqa;


                        //dr["dsqcsdb"] = db;
                        //dr["dssrb"] = srb;
                        //dr["dszcb"] = zcb;
                        //dr["dsyeb"] = yeb;
                        //dr["qshsbqb"] = qshsbqb;
                        //dr["ljqshsbqb"] = ljqshsbqb;
                        //dr["qsjebqb"] = qsjebqb;
                        //dr["ljqsjebqb"] = ljqsjebqb;
                        //dr["grhsbqb"] = grhsbqb;
                        //dr["ljgrhsbqb"] = ljgrhsbqb;
                        //dr["grjebqb"] = grjebqb;
                        //dr["ljgrjebqb"] = ljgrjebqb;
                        //dr["zzhsbqb"] = zzhsbqb;
                        //dr["ljzzhsbqb"] = ljzzhsbqb;
                        //dr["zzjebqb"] = zzjebqb;
                        //dr["ljzzjebqb"] = ljzzjebqb;

                        //dr["ydsqcsdb"] = ydb;
                        //dr["ydssrb"] = ysrb;
                        //dr["ydszcb"] = yzcb;
                        //dr["ydsyeb"] = yyeb;
                        //dr["yqshsbqb"] = yqshsbqb;
                        //dr["yljqshsbqb"] = yljqshsbqb;
                        //dr["yqsjebqb"] = yqsjebqb;
                        //dr["yljqsjebqb"] = yljqsjebqb;
                        //dr["ygrhsbqb"] = ygrhsbqb;
                        //dr["yljgrhsbqb"] = yljgrhsbqb;
                        //dr["ygrjebqb"] = ygrjebqb;
                        //dr["yljgrjebqb"] = yljgrjebqb;
                        //dr["yzzhsbqb"] = yzzhsbqb;
                        //dr["yljzzhsbqb"] = yljzzhsbqb;
                        //dr["yzzjebqb"] = yzzjebqb;
                        //dr["yljzzjebqb"] = yljzzjebqb;

                        //dr["hjbqb"] = db + ydb;
                        //dr["hjbqsrb"] = srb + ysrb;
                        //dr["hjbqzcb"] = zcb + yzcb;
                        //dr["hjbqyeb"] = yeb + yyeb;
                        //dr["hjqshsbqb"] = qshsbqb + yqshsbqb;
                        //dr["hjqshsljb"] = ljqshsbqb + yljqshsbqb;
                        //dr["hjqsjebqb"] = qsjebqb + yqsjebqb;
                        //dr["hjqsjeljb"] = ljqsjebqb + yljqsjebqb;
                        //dr["hjgrhsbqb"] = grhsbqb + ygrhsbqb;
                        //dr["hjgrhsljb"] = ljgrhsbqb + yljgrhsbqb;
                        //dr["hjgrjebqb"] = grjebqb + ygrjebqb;
                        //dr["hjgrjeljb"] = ljgrjebqb + yljgrjebqb;
                        //dr["hjzzhsbqb"] = zzhsbqb + yzzhsbqb;
                        //dr["hjzzhsljb"] = ljzzhsbqb + yljzzhsbqb;
                        //dr["hjzzjebqb"] = zzjebqb + yzzjebqb;
                        //dr["hjzzjeljb"] = ljzzjebqb + yljzzjebqb;

                        //dr["年"] = yyyy;
                        //dr["月1"] = mm;
                        //dr["月2"] = Int32.Parse(mm) + 1 + "";


                        //dt.Rows.Add(dr);
                        //ds.Tables.Add(dt);

                        //ViewData["data"] = ds;

                        return PartialView("FwmmyhReportViewerPartial");
                        //#endregion                    
                    }

                case "ZJGSXBT":
                    {
                        ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtzReport();
                        #region
                        BLL.Fwmmszbt fwmmszbtzBll = new BLL.Fwmmszbt();
                        string where = "sz='自住改善型'";

                        string yyyy = Request.Params["yyyy"];
                        string mm = Request.Params["mm"];
                        string nsr = Request.Params["nsr"];
                        string sfz = Request.Params["sfz"];
                        string btbl = Request.Params["btbl"];
                        string khyh = Request.Params["khyh"];
                        string btrq = Request.Params["btrq"];

                        string setrq = Request.Params["setrq"];

                        ViewData["yyyy"] = yyyy;
                        ViewData["mm"] = mm;
                        ViewData["nsr"] = nsr;
                        ViewData["sfz"] = sfz;
                        ViewData["btbl"] = btbl;
                        ViewData["khyh"] = khyh;
                        ViewData["btrq"] = btrq;

                        if (yyyy != null && yyyy != "")
                        {
                            where += "and datepart(year,btrq) ='" + yyyy + "'";
                        }
                        if (mm != null && mm != "")
                        {
                            where += "and datepart(mm,btrq) ='" + mm + "'";
                        }
                        if (nsr != null && nsr != "")
                        {
                            where += "and nsr like '%" + nsr + "%'";
                        }
                        if (btbl != null && btbl != "")
                        {
                            where += "and btbl = '" + btbl + "'";
                        }
                        if (khyh != null && khyh != "")
                        {
                            where += "and khyh = '" + khyh + "'";
                        }
                        if (sfz != null && sfz != "")
                        {
                            where += "and sfz = '" + sfz + "'";
                        }
                        if (btrq != null && btrq != "")
                        {
                            where += " and btrq = convert(datetime,'" + btrq + "') ";
                        }
                        DataSet dsAll = fwmmszbtzBll.GetAllList(where);

                        DataSet ds = new DataSet();
                        DataTable dt = new DataTable();
                        DataRow dr = dt.NewRow();
                        dt.Columns.Add("编号");
                        dt.Columns.Add("纳税人");
                        dt.Columns.Add("身份证");
                        dt.Columns.Add("房价总额");
                        dt.Columns.Add("补贴额度（%）");
                        dt.Columns.Add("应补贴税额（元）");
                        dt.Columns.Add("开户银行");
                        dt.Columns.Add("帐号");
                        //dt.Columns.Add("合计已缴税款（元）");
                        //dt.Columns.Add("合计应补贴税额（元）");
                        dt.Columns.Add("日期");
                        //dt.Columns.Add("月");

                        decimal yjsksum = 0;
                        decimal ybtjesum = 0;
                        if (yyyy != null && yyyy != "")
                        {
                            btrq = yyyy + "年";
                        }
                        if (mm != null && mm != "")
                        {
                            btrq = yyyy + "年" + mm + "月";
                        }

                        DataSet dsData = fwmmszbtzBll.GetChangeData(where);
                        if (dsData.Tables[0].Rows.Count > 0)
                        {
                            foreach (DataRow drow in dsData.Tables[0].Rows)
                            {
                                if (Int32.Parse(drow["cou"].ToString()) == 1)
                                {
                                    string day = drow["day"].ToString();
                                    btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月" + day.Substring(6, 2) + "日";

                                    if (day.Substring(6, 2) == "11")
                                    {
                                        btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月20日";
                                    }

                                    if (day.Substring(6, 2) == "25")
                                    {
                                        DataSet dsdata = fwmmszbtzBll.GetData(day);

                                        btrq = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "年" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2) + "月5日";
                                    }
                                }
                            }
                        }


                        if (setrq != "" && setrq != null)
                        {
                            btrq = setrq;
                        }
                        else
                        {
                            setrq = btrq;
                        }

                        int count = 0;
                        for (int i = 0; i < dsAll.Tables[0].Rows.Count; i++) 
                        {                           
                            dr = dt.NewRow();
                            dr["编号"] = i + 1;
                            dr["纳税人"] = dsAll.Tables[0].Rows[i]["nsr"].ToString();
                            dr["身份证"] = dsAll.Tables[0].Rows[i]["sfz"].ToString();
                            dr["房价总额"] = dsAll.Tables[0].Rows[i]["yjsk"].ToString();
                            dr["补贴额度（%）"] = dsAll.Tables[0].Rows[i]["btbl"].ToString() + "%";
                            dr["应补贴税额（元）"] = dsAll.Tables[0].Rows[i]["ybtse"].ToString();
                            dr["开户银行"] = dsAll.Tables[0].Rows[i]["khyh"].ToString();
                            dr["帐号"] = dsAll.Tables[0].Rows[i]["zh"].ToString();
                            decimal hjyjsk = decimal.Parse(dsAll.Tables[0].Rows[i]["yjsk"].ToString());
                            decimal hjybtse = decimal.Parse(dsAll.Tables[0].Rows[i]["ybtse"].ToString());
                            yjsksum += hjyjsk;
                            ybtjesum += hjybtse;
                            //dr["合计已缴税款（元）"] = yjsksum;
                            //dr["合计应补贴税额（元）"] = ybtjesum;
                            dr["日期"] = btrq;
                            //dr["月"] = mm;

                            dt.Rows.Add(dr);
                            count++;
                        }
                        int sum = 22 - count % 24;
                        for (int j = 0; j < sum; j++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = "";
                            dr["纳税人"] = "";
                            dr["身份证"] = "";
                            dr["房价总额"] = "";
                            dr["补贴额度（%）"] = "";
                            dr["应补贴税额（元）"] = "";
                            dr["开户银行"] = "";
                            dr["帐号"] = "";
                            dt.Rows.Add(dr);
                        }
                        

                        dr = dt.NewRow();
                        dr["编号"] = "";
                        dr["纳税人"] = "合计";
                        dr["身份证"] = "";
                        dr["房价总额"] = yjsksum;
                        dr["补贴额度（%）"] = "";
                        dr["应补贴税额（元）"] = ybtjesum;
                        dr["开户银行"] = "";
                        dr["帐号"] = "";
                        dt.Rows.Add(dr);

                        //dr = dt.NewRow();
                        //dr["编号"] = "";
                        //dr["纳税人"] = "经办人:";
                        //dr["身份证"] = "";
                        //dr["房价总额"] = "科长（签字）:";
                        //dr["补贴额度（%）"] = "";
                        //dr["应补贴税额（元）"] = "局长（签字）:";
                        //dr["开户银行"] = "";
                        //dr["帐号"] = "";
                        //dt.Rows.Add(dr);

                        ds.Tables.Add(dt);



                        ViewData["data"] = ds;
                        ViewData["Param_PrintDate"] = setrq;
                        return PartialView("FwmmszbtzReportViewerPartial");
                        #endregion
                    }

                case "FWMMCZBT": 
                    {

                        ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtReport();
                        #region
                        BLL.Fwmmszbt fwmmszbtzBll = new BLL.Fwmmszbt();
                        string where = "sz<>'自住改善型'";

                        string yyyy = Request.Params["yyyy"];
                        string mm = Request.Params["mm"];
                        string nsr = Request.Params["nsr"];
                        string sfz = Request.Params["sfz"];
                        string btbl = Request.Params["btbl"];
                        string khyh = Request.Params["khyh"];
                        string btrq = Request.Params["btrq"];
                        string sz = Request.Params["sz"];

                        string setrq = Request.Params["setrq"];

                        ViewData["yyyy"] = yyyy;
                        ViewData["mm"] = mm;
                        ViewData["nsr"] = nsr;
                        ViewData["sfz"] = sfz;
                        ViewData["btbl"] = btbl;
                        ViewData["khyh"] = khyh;
                        ViewData["btrq"] = btrq;
                        ViewData["sz"] = sz;

                        if (yyyy != null && yyyy != "")
                        {
                            where += " and datepart(year,btrq) ='" + yyyy + "'";
                        }
                        if (mm != null && mm != "")
                        {
                            where += "and datepart(mm,btrq) ='" + mm + "'";
                        }
                        if (nsr != null && nsr != "")
                        {
                            where += " and nsr like '%" + nsr + "%'";
                        }
                        if (btbl != null && btbl != "")
                        {
                            where += " and btbl = '" + btbl + "'";
                        }
                        if (sfz != null && sfz != "")
                        {
                            where += " and sfz = '" + sfz + "'";
                        }
                        if (khyh != null && khyh != "")
                        {
                            where += " and khyh = '" + khyh + "'";
                        }
                        if (btrq != null && btrq != "")
                        {
                            where += " and btrq = convert(datetime,'" + btrq + "') ";
                        }
                        if (sz != null && sz != "")
                        {
                            where += " and sz ='" + sz + "'";
                            if (sz == "契税")
                            {
                                sz = "个人普通房屋买卖契税财政补贴审批汇总表";
                            }
                            else if (sz == "个人所得税")
                            {
                                sz = "个人普通房屋买卖个人所得税财政补贴审批汇总表";
                            }
                            else 
                            {
                                sz = "个人普通房屋买卖财政补贴审批汇总表";
                            }
                        }
                        else
                        {
                            sz = "个人普通房屋买卖财政补贴审批汇总表";
                        }
                        DataSet dsAll = fwmmszbtzBll.GetAllList(where);

                        DataSet ds = new DataSet();
                        DataTable dt = new DataTable();
                        DataRow dr = dt.NewRow();
                        dt.Columns.Add("编号");
                        dt.Columns.Add("纳税人");
                        dt.Columns.Add("身份证");
                        dt.Columns.Add("已缴税款（元）");
                        dt.Columns.Add("补贴额度（%）");
                        dt.Columns.Add("应补贴税额（元）");
                        dt.Columns.Add("开户银行");
                        dt.Columns.Add("帐号");
                        //dt.Columns.Add("合计已缴税款（元）");
                        //dt.Columns.Add("合计应补贴税额（元）");
                        dt.Columns.Add("日期");
                        //dt.Columns.Add("月");
                        dt.Columns.Add("税种");

                        decimal yjsksum = 0;
                        decimal ybtjesum = 0;

                        DataSet dsData = fwmmszbtzBll.GetChangeData(where);
                        if (dsData.Tables[0].Rows.Count > 0)
                        {
                            foreach (DataRow drow in dsData.Tables[0].Rows)
                            {
                                if (Int32.Parse(drow["cou"].ToString()) == 1)
                                {
                                    string day = drow["day"].ToString();
                                    btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月" + day.Substring(6, 2) + "日";

                                    if (day.Substring(6, 2) == "11")
                                    {
                                        btrq = day.Substring(0, 4) + "年" + day.Substring(4, 2) + "月20日";
                                    }

                                    if (day.Substring(6, 2) == "25")
                                    {
                                        DataSet dsdata = fwmmszbtzBll.GetData(day);

                                        btrq = dsdata.Tables[0].Rows[0]["day"].ToString().Substring(0, 4) + "年" + dsdata.Tables[0].Rows[0]["day"].ToString().Substring(4, 2) + "月5日";
                                    }
                                }
                            }
                        }


                        if (setrq != "" && setrq != null)
                        {
                            btrq = setrq;
                        }
                        else
                        {
                            setrq = btrq;
                        }
                        int count = 0;
                        for (int i = 0; i < dsAll.Tables[0].Rows.Count; i++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = i + 1;
                            dr["纳税人"] = dsAll.Tables[0].Rows[i]["nsr"].ToString();
                            dr["身份证"] = dsAll.Tables[0].Rows[i]["sfz"].ToString();
                            dr["已缴税款（元）"] = dsAll.Tables[0].Rows[i]["yjsk"].ToString();
                            dr["补贴额度（%）"] = dsAll.Tables[0].Rows[i]["btbl"].ToString() + "%";
                            dr["应补贴税额（元）"] = dsAll.Tables[0].Rows[i]["ybtse"].ToString();
                            dr["开户银行"] = dsAll.Tables[0].Rows[i]["khyh"].ToString();
                            dr["帐号"] = dsAll.Tables[0].Rows[i]["zh"].ToString();
                            decimal hjyjsk = decimal.Parse(dsAll.Tables[0].Rows[i]["yjsk"].ToString());
                            decimal hjybtse = decimal.Parse(dsAll.Tables[0].Rows[i]["ybtse"].ToString());
                            yjsksum += hjyjsk;
                            ybtjesum += hjybtse;
                            //dr["合计已缴税款（元）"] = yjsksum;
                            //dr["合计应补贴税额（元）"] = ybtjesum;
                            //dr["日期"] = btrq;
                            //dr["月"] = mm;
                            dr["税种"] = sz;
                            count++;
                            dt.Rows.Add(dr);
                        }
                        int sum = 22 - count % 24;
                        for (int j = 0; j < sum; j++)
                        {
                            dr = dt.NewRow();
                            dr["编号"] = "";
                            dr["纳税人"] = "";
                            dr["身份证"] = "";
                            dr["已缴税款（元）"] = "";
                            dr["补贴额度（%）"] = "";
                            dr["应补贴税额（元）"] = "";
                            dr["开户银行"] = "";
                            dr["帐号"] = "";
                            dr["税种"] = sz;
                            dt.Rows.Add(dr);
                        }
                        dr = dt.NewRow();
                        dr["编号"] = "";
                        dr["纳税人"] = "合计";
                        dr["身份证"] = "";
                        dr["已缴税款（元）"] = yjsksum;
                        dr["补贴额度（%）"] = "";
                        dr["应补贴税额（元）"] = ybtjesum;
                        dr["开户银行"] = "";
                        dr["帐号"] = "";
                        dt.Rows.Add(dr);

                        //dr = dt.NewRow();
                        //dr["编号"] = "";
                        //dr["纳税人"] = "经办人:";
                        //dr["身份证"] = "";
                        //dr["已缴税款（元）"] = "科长（签字）:";
                        //dr["补贴额度（%）"] = "";
                        //dr["应补贴税额（元）"] = "局长（签字）:";
                        //dr["开户银行"] = "";
                        //dr["帐号"] = "";
                        //dt.Rows.Add(dr);


                        ds.Tables.Add(dt);
                        ViewData["Param_PrintDate"] = setrq;
                        ViewData["data"] = ds;
                        return PartialView("FwmmszbtReportViewerPartial");
                        #endregion
                }

            }
            return View();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public ActionResult FwmmyhReportViewer()
        {
            ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmyhReport();

            return DevExpress.Web.Mvc.ReportViewerExtension.ExportTo(new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmyhReport());
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public ActionResult FwmmszbtzReportViewer()
        {
            ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtzReport();

            return DevExpress.Web.Mvc.ReportViewerExtension.ExportTo(new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtzReport());
        }
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public ActionResult FwmmszbtReportViewer()
        {
            ViewData["Report"] = new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtReport();

            return DevExpress.Web.Mvc.ReportViewerExtension.ExportTo(new ElingOA6_Admin_DSJCJ.Areas.Admin.Views.Print.FwmmszbtReport());
        }
    }
}
